SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='SCOTT';
PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE
----------------------------------------
UNLIMITED TABLESPACE
SQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE='SCOTT';
no rows selected
SQL> select GRANTED_ROLE from dba_role_privs where GRANTEE='SCOTT';
GRANTED_ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
CONNECT
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
CONNECT
To find the role who has the system privileges
SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='RESOURCE';
PRIVILEGE
----------------------------------------
CREATE TRIGGER
CREATE SEQUENCE
CREATE TYPE
CREATE PROCEDURE
CREATE CLUSTER
CREATE OPERATOR
CREATE INDEXTYPE
CREATE TABLE
----------------------------------------
CREATE TRIGGER
CREATE SEQUENCE
CREATE TYPE
CREATE PROCEDURE
CREATE CLUSTER
CREATE OPERATOR
CREATE INDEXTYPE
CREATE TABLE
8 rows selected.
SQL>
To find the role who has the object privileges
SQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE='SELECT_CATALOG_ROLE' and rownum<5;
TABLE_NAME PRIVILEGE
------------------------------ ----------------------------------------
MAP_OBJECT SELECT
OL$ SELECT
OL$HINTS SELECT
OL$NODES SELECT
------------------------------ ----------------------------------------
MAP_OBJECT SELECT
OL$ SELECT
OL$HINTS SELECT
OL$NODES SELECT
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10973950/viewspace-766231/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
