Home -> Mailing Lists -> Oracle-L -> Re: grant <ROLE> to Package - where is my fault?

Re: grant <ROLE> to Package - where is my fault?

From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 9 Feb 2023 10:39:59 +0000
Message-ID: <CAGtsp8kk-M90-52gJvpDi+jg4op-HdCMABBcy_BW3Bc9-EkeMA_at_mail.gmail.com> 








Martin,


As Chris indicates, it's about who can do what when.



B can't create a package body that references A.T1 unless B already has
direct privilege access to A.T1 (at compile time).



The point of "grant role to package" is that this allows A to create a
package handling A's object and then allow B to execute the package without
having direct access to A's objects.




Regards


Jonathan Lewis


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Feb 09 2023 - 11:39:59 CET












Original text of this message