SQL> select * from dba_sys_privs where grantee = 'username';
未选定行
SQL> select * from dba_sys_privs where grantee = 'OMCR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OMCR ADMINISTER DATABASE TRIGGER NO
OMCR CREATE ANY TRIGGER NO
OMCR UNLIMITED TABLESPACE NO
SQL> revoke dba from omcr;
SQL> select * from dba_sys_privs where grantee = 'OMCR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OMCR ADMINISTER DATABASE TRIGGER NO
OMCR CREATE ANY TRIGGER NO
SQL> grant dba to omcr;
授权成功。
SQL> select * from dba_sys_privs where grantee = 'OMCR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OMCR ADMINISTER DATABASE TRIGGER NO
OMCR CREATE ANY TRIGGER NO
OMCR UNLIMITED TABLESPACE NO
SQL> revoke dba from omcr;
撤销成功。
SQL> select * from dba_sys_privs where grantee = 'OMCR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OMCR ADMINISTER DATABASE TRIGGER NO
OMCR CREATE ANY TRIGGER NO
SQL> grant RESOURCE to omcr;
授权成功。
SQL> grant select_catalog_role to omcr;
授权成功。
SQL> grant create any trigger to omcr;
授权成功。
SQL> grant administer database trigger to omcr;
授权成功。
SQL> select * from dba_sys_privs where grantee = 'OMCR';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
OMCR ADMINISTER DATABASE TRIGGER NO
OMCR CREATE ANY TRIGGER NO
OMCR UNLIMITED TABLESPACE NO