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>
Date: Thu, 9 Feb 2023 10:39:59 +0000
Message-ID: <CAGtsp8kk-M90-52gJvpDi+jg4op-HdCMABBcy_BW3Bc9-EkeMA_at_mail.gmail.com>
Martin,
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
As Chris indicates, it's about who can do what when.
Jonathan Lewis
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 09 2023 - 11:39:59 CET