How Can You Grant Privileges On Aq To Other Users?

1.	How Can You Grant Privileges On Aq To Other Users?
Answer» You cannot grant privileges on AQ by using grant STATEMENT SIMILAR to other Oracle objects. grant_system_privilege – Grants AQ SYSTEM privileges revoke_ system_privilege – Revokes AQ system privileges grant_queue_privilege – Grants privileges on AQ revoke_queue_privilege – Revokes privileges on AQ.

Answer»

You cannot grant privileges on AQ by using grant STATEMENT SIMILAR to other Oracle objects.
grant_system_privilege – Grants AQ SYSTEM privileges
revoke_ system_privilege – Revokes AQ system privileges
grant_queue_privilege – Grants privileges on AQ
revoke_queue_privilege – Revokes privileges on AQ.

Discussion