DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ROLE_TAB_PRIVS

Object Details
Object Name: ROLE_TAB_PRIVS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Table privileges granted to roles

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROLE VARCHAR2 (128)
Role Name
OWNER VARCHAR2 (128)
TABLE_NAME VARCHAR2 (128)
Table Name or Sequence Name
COLUMN_NAME VARCHAR2 (128)
Column Name if applicable
PRIVILEGE VARCHAR2 (40)
Table Privilege
GRANTABLE VARCHAR2 (3)
Grant was with the GRANT option
COMMON VARCHAR2 (3)
Privilege was granted commonly
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROLE
,      OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      PRIVILEGE
,      GRANTABLE
,      COMMON
FROM SYS.ROLE_TAB_PRIVS;

Dependencies

[top of page]

SYS.ROLE_TAB_PRIVS references the following:

SchemaSYS
TableCOL$
TableOBJAUTH$
TableSYSAUTH$
TableTABLE_PRIVILEGE_MAP
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.ROLE_TAB_PRIVS is referenced by following:

SchemaPUBLIC
SynonymROLE_TAB_PRIVS