DBA_XS_INHERITED_REALMS

The DBA_XS_INHERITED_REALMS data dictionary view displays all the inherited Real Application Security realms in the database.

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
PARENT_OBJECT VARCHAR2(128)   Name of the parent object
PARENT_SCHEMA VARCHAR2(128)   Schema of the parent object
PRIMARY_KEY VARCHAR2(128)   The column name in the master table
FOREIGN_KEY VARCHAR2(4000)   The column name or value in the detail table
FOREIGN_KEY_TYPE VARCHAR2(5)   Type of the foreign key. Possible values are NAME and VALUE.