User Priviliges - Propagation

user13116877

Hello,

I have two schemas with one queue in each of them. I have set up the propagation between these two queues. The propagation works perfectly as long as the propagated messages are not too big.  When I try to propagate 2K messages then an blob field is being used and the propagation fails with “Not sufficient privileges” error.

I have fixed this problem with granting the users with DBA permissions. But I would prefer to avoid giving these permissions to the users. Is there any other way to solve this problem? Maybe some more granular permissions?

Best Regards

Weronika

gdanby

Yes it's a very good idea not to hand out DBA privileges - I'd revoke them as soon as possible ! Anyway, this is from the Oracle AQ Admin guide "Payloads containing LOBs require users to grant explicit Select, Insert and Update privileges on the queue table for doing enqueues and dequeues."

gdanby

Yes it's a very good idea not to hand out DBA privileges - I'd revoke them as soon as possible ! Anyway, this is from the Oracle AQ Admin guide "Payloads containing LOBs require users to grant explicit Select, Insert and Update privileges on the queue table for doing enqueues and dequeues."