Hi:

I have a role (LDAP_READ) created that grants select privileges on a certain table (LDAP_OWN.LDAP_ENTRY). I have granted LDAP_READ to a user. When I logon as the user I can describe the table and select data from the table. However in a stored procedure, when the tablename is reference I get the error:

PLS-00201: identifier 'LDAP_OWN.LDAP_ENTRY' must be declared

I tried explictly granting select on the ldap_entry table to the user and it appeared to solve the problem.

Does anyone know what is wrong with my LDAP_READ role?

Thanks,

Una.