I was trying out a use of AUTHID CURRENT_USER wherein I encountered the following issue:
CREATE OR REPLACE PACKAGE test_bolinf_api AUTHID CURRENT_USER AS
PROCEDURE test ;
CREATE OR REPLACE PACKAGE BODY test_schema1_api AS
PROCEDURE test AS
c AS NUMBER;
FROM tbl_schema2 WHERE ROWNUM < 5;
EXECUTE priviledge on test_schema1_api has been given to schema2
Now, since AUTHID CURRENT_USER will allow the package to be executed with the priviledges of the CALLING USER, so if I call
It should execute, but it does not. I guess I have missed a step somewhere.
2ndly how does the pkg compile with AUTHID CURRENT_USER construct ?
There is a pkg which has to access tables in other schema of which it does NOT have access to, but the USER/SCHEMA calling the pkg has access to those tables.
Sounds like fun doesn't it.
Cheers 2 all.