Showing posts with label user does not have access to AQ object types. Show all posts
Showing posts with label user does not have access to AQ object types. Show all posts

Wednesday, 18 April 2012

ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

Cause: An attempt was made to issue the CREATE_QUEUE_TABLE command, but the user who issued the command does not have access to internal AQ object types.

Action: Use the DBMS_AQADM.GRANT_TYPE_ACCESS procedure to grant the user access to the AQ object types.