home bbs files messages ]

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