drop user CQ_TTEST cascade;
create user CQ_TTEST
identified by "111111"
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT
password expire
quota unlimited on SYSTEM
quota unlimited on SYSTEM
quota unlimited on users;
-- Grant/Revoke system privileges
grant alter user to CQ_TTEST with admin option;
grant create any synonym to CQ_TTEST with admin option;
grant create materialized view to CQ_TTEST with admin option;
grant create procedure to CQ_TTEST with admin option;
grant create public synonym to CQ_TTEST with admin option;
grant create sequence to CQ_TTEST with admin option;
grant create session to CQ_TTEST with admin option;
grant create table to CQ_TTEST with admin option;
grant create trigger to CQ_TTEST with admin option;
grant create user to CQ_TTEST with admin option;
grant create view to CQ_TTEST with admin option;
grant drop public synonym to CQ_TTEST with admin option;
grant drop user to CQ_TTEST with admin option;
grant dba to CQ_TTEST;
create user CQ_TTEST
identified by "111111"
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT
password expire
quota unlimited on SYSTEM
quota unlimited on SYSTEM
quota unlimited on users;
-- Grant/Revoke system privileges
grant alter user to CQ_TTEST with admin option;
grant create any synonym to CQ_TTEST with admin option;
grant create materialized view to CQ_TTEST with admin option;
grant create procedure to CQ_TTEST with admin option;
grant create public synonym to CQ_TTEST with admin option;
grant create sequence to CQ_TTEST with admin option;
grant create session to CQ_TTEST with admin option;
grant create table to CQ_TTEST with admin option;
grant create trigger to CQ_TTEST with admin option;
grant create user to CQ_TTEST with admin option;
grant create view to CQ_TTEST with admin option;
grant drop public synonym to CQ_TTEST with admin option;
grant drop user to CQ_TTEST with admin option;
grant dba to CQ_TTEST;
里面的CQ_TTEST是用户 identified by "111111"是密码