107 DBMS_STREAMS_AUTH

Summary of DBMS_STREAMS_AUTH Subprograms

GRANT_ADMIN_PRIVILEGE Procedure

This procedure either grants the privileges needed by a user to be a Streams administrator directly, or generates a script that can be used to grant these privileges.

Syntax

DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(
   grantee           IN  VARCHAR2,
   grant_privileges  IN  BOOLEAN   DEFAULT TRUE,
   file_name         IN  VARCHAR2  DEFAULT NULL,
   directory_name    IN  VARCHAR2  DEFAULT NULL);

Parameters

Usage Notes

The user who runs the procedure must be an administrative user who can grant privileges to other users.

Specifically, the procedure grants the following privileges to the specified user:

• The RESTRICTED SESSION system privilege

• EXECUTE on the following packages:

  • DBMS_APPLY_ADM

  • DBMS_AQ

  • DBMS_AQADM

  • DBMS_AQIN

  • DBMS_AQELM

  • DBMS_CAPTURE_ADM

  • DBMS_FLASHBACK

  • DBMS_PROPAGATION_ADM

  • DBMS_RULE_ADM

  • DBMS_STREAMS_ADM

  • DBMS_STREAMS_MESSAGING

  • DBMS_TRANSFORM

• Privileges to enqueue messages into and dequeue messages from any queue

• Privileges to manage any queue

• Privileges to create, alter, and execute any of the following types of objects in the user's own schema and in other schemas:

  • Evaluation contexts

  • Rule sets

  • Rules

  In addition, the grantee has the ability to grant these privileges to other users.

• SELECT privilege on data dictionary views related to Streams

• The ability to allow a remote Streams administrator to perform administrative actions through a database link by connecting to the grantee. This ability is enabled by running the GRANT_REMOTE_ADMIN_ACCESS procedure in this package.

  Note:

  • To view all of the statements run by the procedure in detail, you can use the procedure to generate a script and then view the script in a text editor.

  • This procedure does not grant any roles to the grantee.

  • This procedure grants only the privileges necessary to configure and administer a Streams environment. You can grant more privileges to the grantee if necessary.

  See Also:

  • "GRANT_REMOTE_ADMIN_ACCESS Procedure"

  • Oracle Streams Concepts and Administration for more information about configuring a Streams administrator

GRANT_REMOTE_ADMIN_ACCESS Procedure

This procedure enables a remote Streams administrator to perform administrative actions at the local database by connecting to the grantee using a database link.

Syntax

DBMS_STREAMS_AUTH.GRANT_REMOTE_ADMIN_ACCESS(
   grantee  IN  VARCHAR2);

Parameters

Usage Notes

Typically, you run the procedure and specify a grantee at a local source database if a downstream capture process captures changes originating at the local source database. The Streams administrator at a downstream capture database administers the source database using this connection. You can also run the procedure at a database running an apply process so that a remote Streams administrator can set instantiation SCNs at the local database.

REVOKE_ADMIN_PRIVILEGE Procedure

This procedure either revokes Streams administrator privileges from a user directly, or generates a script that can be used to revoke these privileges.

Syntax

DBMS_STREAMS_AUTH.REVOKE_ADMIN_PRIVILEGE(
   grantee            IN  VARCHAR2,  
   revoke_privileges  IN  BOOLEAN   DEFAULT TRUE,
   file_name          IN  VARCHAR2  DEFAULT NULL,
   directory_name     IN  VARCHAR2  DEFAULT NULL);

Parameters

Usage Notes

The user who runs this procedure must be an administrative user who can revoke privileges from other users. Specifically, this procedure revokes the privileges granted by running the GRANT_ADMIN_PRIVILEGE procedure in this package.

REVOKE_REMOTE_ADMIN_ACCESS Procedure

This procedure disables a remote Streams administrator from performing administrative actions by connecting to the grantee using a database link.

Syntax

DBMS_STREAMS_AUTH.REVOKE_REMOTE_ADMIN_ACCESS(
   grantee  IN  VARCHAR2);

Parameters