DBA_DATA_ROLES

DBA_DATA_ROLES displays all Oracle Deep Data Security (Deep Sec) data roles defined in the database.

Column Datatype NULL Description
DATA_ROLE VARCHAR2(128)   Name of the data role
MAPPED_TO VARCHAR2(4000)   External name (from an identity provider) that is mapped to the data role
ENABLED_BY_DEFAULT BOOLEAN   Indicates whether the data role is enabled by default (TRUE) or not (FALSE)

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