Samuel Learning

-- 注釋： Create tablespace

--revoke "DBA" from sam

--drop tablespace tstest including contents and datafiles;

--drop user sam CASCADE;

?

CREATE TABLESPACE "tstest"

??? LOGGING

??? DATAFILE 'D:/oracle/oradata/OAERP/TSTEST.ORA' SIZE 100M

??? REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT? AUTO ;

???

CREATE USER "SAM"? PROFILE "DEFAULT"

??? IDENTIFIED BY "1qa2ws3ed" DEFAULT TABLESPACE "TSTEST"

??? TEMPORARY TABLESPACE "TEMP"

??? ACCOUNT UNLOCK;

?

?

grant connect to "SAM"? with admin option;

ALTER USER "SAM" DEFAULT ROLE? ALL;

?

grant create procedure to SAM;

grant create sequence to SAM;

grant create table to SAM;

grant create view to SAM;

?

grant drop any procedure to SAM;

grant drop any sequence to SAM;

grant drop any table to SAM;

grant drop any view to SAM;

?

alter user SAM quota unlimited on TSTEST;