To declare an object in PL/SQL

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?

Quote:

---

Originally posted by peach_partner 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?

---

Perhaps grant SELECT on A.test to B?

'grant SELECT on A.TEST to B'..... It already has been granted before I found this problem.

Actually, I granted ALL PRIVILEGE on user A to B.