Help:plsql problem with roles (pls 201)

Hi,

I have a plsql procedure with the following statements

a b.field%type;

select count(*)
from b
into a;

b is in another schema d. There exists a public synonym for b and as far as privileges
concerned there is a role c and on the table there exists select, update, delete and insert
privileges on b for the role c. The user with the plsql procedure has role c assigned to
him. It's possible for him to do a select in sqlplus on b and it gets result back, so why
is he getting pls-201 identiefier d.b must be declared.

When i directly give select privilege on b to the user the procedure works. Is there
anyway to solve this with roles ?

Thanks a lot,

Jeroen

jeroen.van.sluisdam_at_vrijuit.nl Received on Sat Jan 03 1998 - 00:00:00 CST