Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_AQADM , 28 of 31
This procedure grants an AQ Internet agent the privileges of a specific database user. The AQ Internet agent should have been previously created using the CREATE_AQ_AGENT procedure.
DBMS_AQADM.ENABLE_DB_ACCESS ( agent_name IN VARCHAR2, db_username IN VARCHAR2)
Parameter | Description |
---|---|
agent_name |
Specifies the username of the AQ Internet agent |
db_username |
Specified the database user whose privileges are to be granted to the AQ Internet agent |
The SYS.AQ$INTERNET_USERS view has a list of all AQ Internet agents and the names of the database users whose privileges are granted to them.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|