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

VIEW: SYS.CDB_XS_ROLES

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

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (128)
Name of the role
GUID RAW (16)
GUID of the role
EXTERNAL_SOURCE VARCHAR2 (128)
External source of the role
DEFAULT_ENABLED VARCHAR2 (3)
Indicates whether the role is default enabled (YES) or not (NO)
START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Effective start date for the role
END_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Effective end date for the role
DESCRIPTION VARCHAR2 (4000)
Description of the role
CON_ID NUMBER

container id
Query Text

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


SELECT NAME
,      GUID
,      EXTERNAL_SOURCE
,      DEFAULT_ENABLED
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      CON_ID
FROM SYS.CDB_XS_ROLES;

Dependencies

[top of page]

SYS.CDB_XS_ROLES does not reference any database object

SYS.CDB_XS_ROLES is referenced by following:

SchemaPUBLIC
SynonymCDB_XS_ROLES