DROP USER caliburn CASCADE; CREATE USER caliburn IDENTIFIED BY caliburn DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE, UNLIMITED TABLESPACE,CREATE TRIGGER TO caliburn; ALTER USER caliburn quota unlimited ON users; DROP USER content CASCADE; CREATE USER content IDENTIFIED BY content DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM, SELECT ANY DICTIONARY, CREATE SEQUENCE, GRANT ANY PRIVILEGE, UNLIMITED TABLESPACE,CREATE TRIGGER TO content; ALTER USER content quota unlimited ON users; |