Oracle Nuggets

From thecentric

Create User & Create Role:

 create user sean identified by "password"
      DEFAULT TABLESPACE users  
      TEMPORARY TABLESPACE temp
      QUOTA UNLIMITED ON users;
 
 CREATE ROLE new_role;
 
 GRANT CREATE session, CREATE table,
      CREATE view, CREATE procedure,
      CREATE synonym, CREATE sequence
      TO new_role;
 
 GRANT new_rol TO sean;