Static Data Dictionary Views, 312 of 452

ROLE_TAB_PRIVS

ROLE_TAB_PRIVS contains information about 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`