ORA-01031 While Adding A Subscriber To A Queue Owned By SYS By A NON-SYS User
(Doc ID 2547903.1)
Last updated on JANUARY 24, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
When a Non-SYS user (with AQ_ADMINISTRATOR_ROLE and MANAGE ANY QUEUE privileges) tries to add a queue subscriber to SYS.ALERT_QUE which is owned by SYS, recieves error- ORA-01031: insufficient privileges
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document