plsql - Grant permission to queues to another schema in oracle -


hi have oracle queue in 1 schema namely aqs

sample queue

   begin dbms_aqadm.create_queue(      queue_name          => 'aqs.mob_msg',      queue_table         => 'aqs.mob_qt',      queue_type          =>  0,      max_retries         =>  5,      retry_delay         =>  0,      dependency_tracking =>  false,      comment             => 'sample');   end; 

i have corresponding queue table created.it works fine.

now want provide select grant queue using schema named "mob".how provide grant schema queue?do need provide select access queue or queue table.

i tried using grant select on aqs.mob_msg mob , not working! saying object not exists.

execute dbms_aqadm.grant_queue_privilege (     privilege     =>     'all', or (enqueue) or (dequeue)    queue_name    =>     'aqs.mob_msg',     grantee       =>     'grantee_user',     grant_option  =>      false/true); 

if want grant direct access queue table. have this.grant select on mob_qt xxxx


Comments

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -