Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLESPACE TB_CTUSR DATAFILE '/home/oracle/oradata/ctusr001.dbf' SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
- CREATE TEMPORARY TABLESPACE TB_CTTMPUSR TEMPFILE '/home/oracle/oradata/cttmpusr001.dbf'SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
- CREATE USER RICMUSR IDENTIFIED BY XXXXXXXX DEFAULT TABLESPACE TB_CTUSR QUOTA UNLIMITED ON TB_CTUSR TEMPORARY TABLESPACE TB_CTTMPUSR;
- GRANT DBA, CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO RICMUSR;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement