Granting System Privileges

Figure 13-22 Use Case Diagram: Grant System Privileges

Text description of the illustration adq13jad22.gif

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Operational Interface -- Basic Operations"

Purpose

Grant AQ system privileges to a user/roles.

Usage Notes

Initially only SYS and SYSTEM can use this procedure successfully.

The privileges are ENQUEUE_ANY, DEQUEUE_ANY and MANAGE_ANY.

Syntax

See Java (JDBC): Oracle9i Supplied Java Packages Reference, oracle.jms, AQjmsSession.grantSystemPrivilege

Example

TopicSession             t_sess;

((AQjmsSession)t_sess).grantSystemPrivilege("ENQUEUE_ANY", "scott", false);