ALL_XS_REALM_CONSTRAINTS

The ALL_XS_REALM_CONSTRAINTS data dictionary view displays all existing Real Application Security realms accessible to the current user.

Column Datatype NULL Description
POLICY VARCHAR2(128)   Name of the data security policy
POLICY_OWNER VARCHAR2(128)   Owner of the data security policy
REALM_ORDER NUMBER NOT NULL The order of the realm within the data security policy
REALM_TYPE VARCHAR2(13)   The type of the realm. Valid values are REGULAR, PARAMETERIZED, and INHERITED.
REALM_DESCRIPTION VARCHAR2(4000)    
STATIC VARCHAR2(7)   Indicates whether the realm is STATIC or DYNAMIC
REALM VARCHAR2(4000)   The data realm.
ACL VARCHAR2(128)   ACL associated with the realm if the realm type is REGULAR
ACL_OWNER VARCHAR2(128)   Owner of the ACL associated with the REGULAR realm
PARENT_OBJECT VARCHAR2(128)   Name of the parent object if the realm type is INHERITED
PARENT_SCHEMA VARCHAR2(128)   Schema of the parent object if the realm type is INHERITED