Advertisement
Guest User

lmao

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