Hi all,

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

What should I/user B do next?