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