Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle.server    |    Oracle Sysadmins question their careers    |    44,300 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 43,074 of 44,300    |
|    "Michel Cadot"     |
|    Re: Security enhancements in Oracle 12c     |
|    18 Dec 17 08:53:06    |
   
    a écrit dans le message de news: bb3a   
   436-c7d7-4d05-a76f-52333a230cdd@googlegroups.com...   
   | 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.   
   |   
   |   
      
   I suggest you post a complete test case we can reproduce.   
      
   Regards   
   Michel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca