|
-- 注释： 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;
|