Security enhancements in Oracle 12c R2 causing ORA-01031
From: <kaku.sivakumar_at_gmail.com>
Date: Wed, 13 Dec 2017 21:16:28 -0800 (PST)
Message-ID: <bb3a2436-c7d7-4d05-a76f-52333a230cdd_at_googlegroups.com>
[Quoted] Hi All
Date: Wed, 13 Dec 2017 21:16:28 -0800 (PST)
Message-ID: <bb3a2436-c7d7-4d05-a76f-52333a230cdd_at_googlegroups.com>
[Quoted] Hi All
Our Application works fine till 12c R1 with below functionality.
User A: plication uses objects from Schema A
Role R : Role R have access to Objects on schema A
User B : Role R is granted to User B. So User B can access objects on User A
This works fine till 12c R1.
But same functionality giving Error ORA-01031 Insufficient privileges error in App
Please let us know your thoughts on this.
Is there any parameter to turn off ONLY the security enhancements in 12c R2? Please suggest. Received on Thu Dec 14 2017 - 06:16:28 CET