Search Results user_policies

Overview

XDB.DBMS_XDBZ0 is a private helper package body within the Oracle XML DB (XDB) schema that underpins the Repository Access Control Lists (ACLs) and resource-security model. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it is a component of the embedded XML DB database option rather than an EBS-owned application object, yet it appears in ETRM inventories because EBS technical objects such as the Oracle Applications Tablespace Model (OATM) administration, XML Publisher, and the integration repository reference the XDB schema indirectly. The package body's primary responsibility is to implement the low-level primitives that kernel packages (notably XDB.DBMS_XDBZ and XDB.DBMS_XDBZ_LIB) use to create, drop, and validate the row-level security policies that protect resources stored in the XML DB Repository and in XMLType tables.

Key Procedures and Functions

The documented metadata records zero publicly exposed application-level procedures or functions for this package body. Its program units are private support routines whose names are visible in the dependency trail — the internal helper SETMODFLG and the table type predicate ISXMLTYPETABLE — and they are consumed exclusively by sibling XDB packages rather than by application code. SETMODFLG toggles a modification flag used during ACL evaluation and caching, while ISXMLTYPETABLE determines whether a given object is an XMLType table prior to policy enforcement. Both are invoked from DBMS_XDBZ and DBMS_XDBZ_LIB; neither is part of any documented EBS API surface, and no parameter lists should be assumed from the ETRM entry alone.

Tables Accessed

The package body performs its security manipulations through a small set of SQL interfaces. It reads USER_POLICIES and ALL_POLICIES — the standard Oracle data dictionary views that expose row-level security policies visible to the current and all users respectively — to discover which policies already guard repository objects. It calls DBMS_RLS to add, drop, or refresh those policies, DBMS_SQL and DBMS_ASSERT for dynamic SQL construction and input validation, and DBMS_STANDARD for general error handling. In EBS the ALL_POLICIES and USER_POLICIES views are the objects most often surfaced by the user's search, because ACL diagnostics in the EBS technology stack frequently query them to confirm that the correct XDB policies are installed.

Usage Notes

DBMS_XDBZ0 is not invoked directly from EBS forms, concurrent programs, or customer-written PL/SQL. It executes implicitly whenever the XML DB Repository enforces or changes a resource ACL — for example, during the creation of repository folders under /sys, when Oracle XML Publisher writes concurrent program output to the repository, or when EBS patching (adpatch/autopatch) reapplies XML DB security definitions. It is referenced by three higher-level objects (DBMS_XDBZ, DBMS_XDBZ_LIB, and SECURITY_LIB) and references none of its own consumers, confirming its position as a leaf-level implementation dependency. Because the schema is XDB, DBA-level privileges are required to inspect the source, and any modification is unsupported; upgrades are applied exclusively through Oracle database patches rather than through EBS patch drivers.