DBA_DATA_ROLE_GRANTS

DBA_DATA_ROLE_GRANTS displays all Oracle Deep Data Security (Deep Sec) data role grants, and the database role grants assigned to data roles, in the database.

Column Datatype NULL Description
DATA_ROLE VARCHAR2(128)   Name of the granted role
ROLE_TYPE VARCHAR2(13)  

Type of granted role:

  • DATA ROLE

  • DATABASE ROLE
GRANTEE VARCHAR2(128)   Name of the grantee
GRANTEE_TYPE VARCHAR2(20)  

Type of grantee:

  • APPLICATION IDENTITY

  • DATA ROLE

  • END USER
START_TIME VARCHAR2(28)   Start time from which the grant is valid
END_TIME VARCHAR2(28)   End time until which the grant is valid

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.2.