Search Results dbms_xstream_auth




Overview
Explore in AI Chat

Overview

DBMS_XSTREAM_AUTH is a SYS-owned PL/SQL package that administers the privilege model for Oracle Streams and XStream replication. In Oracle E-Business Suite 12.1.1 and 12.2.2, the package is not part of the functional application layer; rather, it is an Oracle Database infrastructure component that EBS relies upon indirectly whenever a Streams-based data propagation, staged apply, or logical standby configuration is deployed. Its purpose is to grant and revoke the administrative privileges required by users, capture processes, propagation senders, and apply processes to operate on Streams queues and rules.

Within the EBS technical stack the package is classified as OTHER, and its documented status is VALID in the SYS schema. It depends only on the SYS schema and the STANDARD package, and it is exposed to the DBMS_XSTREAM_AUTH synonym under PUBLIC and SYS. No other EBS packages reference it, and it references no application tables through APPS synonyms, confirming its role as a database-level security utility rather than an EBS business API.

Key Procedures and Functions

The documented interface comprises four procedures:

  • GRANT_ADMIN_PRIVILEGE — Grants the Streams/XStream administrative privileges and roles to a designated user or role. It is the primary entry point used when preparing an account to own or manage capture, propagation, and apply components.
  • REVOKE_ADMIN_PRIVILEGE — Performs the inverse operation, removing the administrative privileges previously granted. It is used during decommissioning, role separation, or security remediation.
  • GRANT_REMOTE_ADMIN_ACCESS — Enables a remote database to act as an administrative client, allowing Streams/XStream administration to be performed across a database link rather than only locally.
  • REVOKE_REMOTE_ADMIN_ACCESS — Removes the remote administrative access established by the preceding procedure.

Parameter lists are intentionally omitted here; the documented metadata names the procedures only. Administrators should consult the Oracle-supplied package specification in SYS for exact signatures before invoking them.

Tables Accessed

The ETRM metadata records no tables referenced via APPS synonyms for this package. This is expected: DBMS_XSTREAM_AUTH operates against Oracle data dictionary and Streams internal objects owned by SYS, such as privilege and rule-set metadata, rather than against EBS application tables. Consequently, no EBS schema objects are read or written directly, and the package presents no risk of application data modification.

Usage Notes

DBMS_XSTREAM_AUTH is invoked from SQL*Plus or another privileged client by a DBA, never from an EBS form or concurrent program. Typical invocation points include initial setup of a Streams or XStream topology, migration projects, and periodic access reviews in which administrative grants must be re-validated. Because the package resides in SYS and alters security configuration, execution requires SYSDBA or an equivalently privileged account.

For EBS 12.1.1 and 12.2.2 environments, the package should be treated as database infrastructure supporting replication features, not as an application extension point. Custom code should not call these procedures as part of an EBS business flow. Any change to Streams administrative privileges should follow the standard change-control process, since incorrect grants can either disable replication or unnecessarily widen the administrative attack surface of the database.