Print Thread
Minor bug: View user, Object Privs tab, missing AQ privs
#38394 07/13/10 08:05 PM
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
bcoulam Offline OP
Member
OP Offline
Member
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
We are using Oracle's queueing facilities. Part of the setup involves granting another schema rights to dequeue from the schema that owns the queue. This is done through the dbms_aqadm.grant_queue_privilege routine. When that is successful, one can see the privilege in dba_tab_privs.

If you attempt to view the same privileges through the View context menu option for the schema, then click the Object privileges tab, you will see the queue name in the object column, but there are no vertical columns to accommodate AQ privs like ENQUEUE and DEQUEUE.

Re: Minor bug: View user, Object Privs tab, missing AQ privs
bcoulam #38399 07/14/10 12:13 PM
Joined: Aug 1999
Posts: 22,239
Member
Offline
Member
Joined: Aug 1999
Posts: 22,239
We'll check it out.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 15 (0.012s) Memory: 2.5002 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-06-26 12:53:03 UTC
Valid HTML 5 and Valid CSS