VIEW: SYS.USER_XS_INHERITED_REALMS

Source

View Text - Preformatted

select policy, realm_order, parent_object, parent_schema, primary_key,
       foreign_key, foreign_key_type
  from sys.dba_xs_inherited_realms
 where policy_owner = sys_context('USERENV','CURRENT_USER')

View Text - HTML Formatted

SELECT POLICY
, REALM_ORDER
, PARENT_OBJECT
, PARENT_SCHEMA
, PRIMARY_KEY
, FOREIGN_KEY
, FOREIGN_KEY_TYPE
FROM SYS.DBA_XS_INHERITED_REALMS
WHERE POLICY_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')