5.308 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.