有了vault,sys用户不在无所不能
[@more@]SQL> SELECT *
2 FROM DBA_ROLE_PRIVS
3 WHERE GRANTED_ROLE IN ('DV_ACCTMGR');
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
DVSYS DV_ACCTMGR YES YES
DBVM DV_ACCTMGR YES YES
SQL> SELECT * FROM DBA_SYS_PRIVS where grantee='DV_ACCTMGR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
DV_ACCTMGR CREATE USER NO
DV_ACCTMGR DROP USER NO
DV_ACCTMGR DROP PROFILE NO
DV_ACCTMGR ALTER PROFILE NO
DV_ACCTMGR CREATE SESSION YES
DV_ACCTMGR CREATE PROFILE NO
DV_ACCTMGR ALTER USER NO
已选择7行。
SQL> create user b identified by b;
用户已创建。
SQL> show user
USER 为 "DBVM"
SQL>
--============================
SQL> create user b identified by b;
create user b identified by b
*
第 1 行出现错误:
ORA-01031: 权限不足
SQL> show user
USER 为 "SYS"
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1060194/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1060194/