Problems with roles.

[una]

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.

[tamilselvan]

Create a public synonym on the table.

[marist89]

Stored procedures don't respect roles. You have to grant the priviledges directly.

[una]

Hi:

A public synonym actually exists for the table. But I think I found the answer in the Oracle documentation.

"roles are not meant to be used for application developers, because the privileges to access schema objects within stored programmatic constructs need to be granted directly"

Thanks.