ROLE_TAB_PRIVS

Oracle 11gR1

ROLE_TAB_PRIVS describes table privileges granted to roles. Information is provided only about roles to which the user has access.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Name of the role
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)		Name of the column, if applicable
PRIVILEGE	VARCHAR2(40)	NOT NULL	Object privilege granted to the role
GRANTABLE	VARCHAR2(3)		YES if the role was granted with ADMIN OPTION; otherwise NO

Note:

1. Show what table privileges are granted to a role

select owner || '.' || table_name "TABLE"

, column_name

, privilege

, grantable

from role_tab_privs

where role like 'DBA';

TABLE	COLUMN_NAME	PRIVILEGE	GRANTABLE
SYS.AW$		DEBUG	NO
SYS.AW$		SELECT	NO
SYS.AWSEQ$		ALTER	NO
SYS.AWSEQ$		SELECT	NO
SYS.AW_OBJ$		DEBUG	NO
SYS.AW_OBJ$		SELECT	NO
SYS.AW_PROP$		SELECT	NO
SYS.AW_PROP$		DEBUG	NO
SYS.DBMS_DEFER_QUERY		EXECUTE	NO
SYS.DBMS_DEFER_SYS		EXECUTE	NO
SYS.DBMS_FEATURE_USAGE_REPORT		EXECUTE	NO
SYS.DBMS_FLASHBACK		EXECUTE	NO
SYS.DBMS_INTERNAL_LOGSTDBY		EXECUTE	NO
SYS.DBMS_LOGSTDBY		EXECUTE	NO
SYS.DBMS_MONITOR		EXECUTE	NO
SYS.DBMS_RESUMABLE		EXECUTE	NO
SYS.DBMS_SERVER_ALERT		EXECUTE	NO
SYS.DBMS_SERVER_TRACE		EXECUTE	NO
SYS.DBMS_SERVICE		EXECUTE	NO
SYS.DBMS_STORAGE_MAP		EXECUTE	NO
SYS.DBMS_TDB		EXECUTE	NO
SYS.DBMS_UADV_ARR		EXECUTE	NO
SYS.DBMS_UNDO_ADV		EXECUTE	NO
SYS.DBMS_WORKLOAD_REPOSITORY		EXECUTE	NO
SYS.LOAD_UNDO_STAT		EXECUTE	NO
SYS.MAP_OBJECT		ON COMMIT REFRESH	NO
SYS.MAP_OBJECT		QUERY REWRITE	NO
SYS.MAP_OBJECT		FLASHBACK	NO
SYS.MAP_OBJECT		UPDATE	NO
SYS.MAP_OBJECT		SELECT	NO
SYS.MAP_OBJECT		INSERT	NO
SYS.MAP_OBJECT		DELETE	NO
SYS.MAP_OBJECT		DEBUG	NO
SYS.MAP_OBJECT		ALTER	NO
SYS.OUTLN_EDIT_PKG		EXECUTE	NO
SYS.OUTLN_PKG		EXECUTE	NO
SYS.PS$		SELECT	NO
SYS.PS$		DEBUG	NO
SYS.RESET_UNDO_STAT		EXECUTE	NO
WKSYS.WK$SYS_CONFIG		UPDATE	NO

Oracle data dictionary views

Oracle dynamic performance views