DROP USER XX CASCADE 删除用户

sqlplus /nolog

conn / as sysdba

CREATE USER xixixi IDENTIFIED BY “hahaha” DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;

GRANT CONNECT TO xixixi;
GRANT RESOURCE TO xixixi;
ALTER USER xixixi DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO xixixi;
GRANT CREATE SESSION TO xixixi;
GRANT SELECT ANY DICTIONARY TO xixixi;
GRANT UNLIMITED TABLESPACE TO xixixi;
GRANT SELECT ANY DICTIONARY TO xixixi;

select name from v$database;
select instance_name from v$instance;
select name from v$datafile;

 

http://www.cnblogs.com/loong-hon/p/5827237.html

发表评论

邮箱地址不会被公开。 必填项已用*标注