DBA_XS_PRINCIPALS

The DBA_XS_PRINCIPALS data dictionary view describes all the existing application users and application roles in the database.

Column Datatype NULL Description
NAME VARCHAR2(128)   Name of the principal (application user or application role)
GUID RAW(16)   Globally unique identifier for the principal
TYPE VARCHAR2(12)  

Type of the principal. Possible values are:

  • USER

  • ROLE

  • DYNAMIC ROLE

EXTERNAL_SOURCE VARCHAR2(128)   External source of the principal
DESCRIPTION VARCHAR2(4000)   Description of the principal