Hi all,
The error "PLS-00201: identifier 'A.TEST' must be declared" was returned when user B have created a procedure as below
I already granted SELECT on every B's tables to user A and also user B can query them.Code:CREATE or REPLACE PROCEDURE TEST is CURSOR T IS SELECT id FROM a.test; <<<< Error in this line BEGIN .... END TEST;
What should I/user B do next?