Hi. We are using Oracle Database 12c .
Can I create a package say with 3 program units: 2 of them invoker's rights procedures and one owner's rights ?
Example:
CREATE PACKAGE MY_PKS AS
PROCEDURE p_1 (par1 in number) AUTHID CURRENT_USER IS
PROCEDURE P_2 (par1 number);
END MY_PKS ;
I mean the invoker's rights can be granular o does it involves or applies to all the program units defined?
Thanks in advance !!!
--