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

VIEW: SYS.DBA_XS_REALM_CONSTRAINTS

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

All the Real Application Security realms defined in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
POLICY VARCHAR2 (128)
Name of the data security policy
POLICY_OWNER VARCHAR2 (128)
Owner of the data security policy
REALM_ORDER NUMBER
Yes The order of the realm within the data security policy
REALM_TYPE VARCHAR2 (13)
The type of the realm. Possible values are REGULAR, PARAMETERIZED, and INHERITED
STATIC VARCHAR2 (7)
Indicates whether the realm is static (YES) or not (NO)
REALM VARCHAR2 (4000)
The realm
REALM_DESCRIPTION VARCHAR2 (4000)
The realm description
ACL VARCHAR2 (128)
Name of the associated ACL for REGULAR realm
ACL_OWNER VARCHAR2 (128)
Owner of the associated ACL for REGULAR realm
PARENT_OBJECT VARCHAR2 (128)
Name of the parent object if the type of the realm is INHERITED
PARENT_SCHEMA VARCHAR2 (128)
Schema of the parent object if the type of the realm is INHERITED
Query Text

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


SELECT POLICY
,      POLICY_OWNER
,      REALM_ORDER
,      REALM_TYPE
,      STATIC
,      REALM
,      REALM_DESCRIPTION
,      ACL
,      ACL_OWNER
,      PARENT_OBJECT
,      PARENT_SCHEMA
FROM SYS.DBA_XS_REALM_CONSTRAINTS;

Dependencies

[top of page]

SYS.DBA_XS_REALM_CONSTRAINTS references the following:

SchemaSYS
TableXS$INSTSET_ACL
TableXS$INSTSET_INH
TableXS$INSTSET_LIST
TableXS$INSTSET_RULE
TableXS$OBJ
SYS.DBA_XS_REALM_CONSTRAINTS is referenced by following:

SchemaPUBLIC
SynonymDBA_XS_REALM_CONSTRAINTS
SchemaSYS
ViewUSER_XS_REALM_CONSTRAINTS