DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.CDB_XS_PRINCIPALS

Object Details
Object Name: CDB_XS_PRINCIPALS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All the Real Application Security principals defined in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (128)
Name of the principal
GUID RAW (16)
GUID of the principal
TYPE VARCHAR2 (12)
Type of the principal. Possible values are USER, ROLE, or DYNAMIC ROLE
EXTERNAL_SOURCE VARCHAR2 (128)
External source of the principal
DESCRIPTION VARCHAR2 (4000)
Description of the principal
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      GUID
,      TYPE
,      EXTERNAL_SOURCE
,      DESCRIPTION
,      CON_ID
FROM SYS.CDB_XS_PRINCIPALS;

Dependencies

[top of page]

SYS.CDB_XS_PRINCIPALS does not reference any database object

SYS.CDB_XS_PRINCIPALS is referenced by following:

SchemaPUBLIC
SynonymCDB_XS_PRINCIPALS