Create an Oracle User

From SemanticLab

 Prompt drop USER BIBDB;
 DROP USER BIBDB CASCADE
 /
 
 Prompt User BIBDB;
 --
 -- BIBDB  (User) 
 --
 CREATE USER BIBDB
   IDENTIFIED BY <password>
   DEFAULT TABLESPACE USERS
   TEMPORARY TABLESPACE TEMP
   PROFILE DEFAULT
   ACCOUNT UNLOCK
 /
   -- 3 Roles for BIBDB 
  -- GRANT DBA TO BIBDB WITH ADMIN OPTION
 /
   GRANT CONNECT TO BIBDB WITH ADMIN OPTION
 /
   GRANT RESOURCE TO BIBDB WITH ADMIN OPTION
 /
   ALTER USER BIBDB DEFAULT ROLE ALL
 /
   -- 1 System Privilege for BIBDB 
   GRANT UNLIMITED TABLESPACE TO BIBDB WITH ADMIN OPTION
 /
   -- 1 Tablespace Quota for BIBDB 
   ALTER USER BIBDB QUOTA UNLIMITED ON USERS
 /