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
Post a Comment