[Home] [Help] [Dependency Information]
Object Name: | DBA_XS_ROLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All the Real Application Security roles defined in the database
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 |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, GUID
, EXTERNAL_SOURCE
, DEFAULT_ENABLED
, START_DATE
, END_DATE
, DESCRIPTION
FROM SYS.DBA_XS_ROLES;
|
|
|