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?