Roles and Privileges

[CHALAVADI]

User A has been granted Developer Role to which select any table, update any table system privileges have been granted.

Now user A is trying to compile a package which access user B's emp table for which a public synonym was created.

Compilation was failing with following error
PLS-00201: identifier 'EMP' must be declared.

I am trying to find out the reason.

Does user A need explicit SELECT ANY TABLE, UPDATE ANY TABLE System privilege granted to him eventhough he was granted them via DEVELOPER role

Please advise.

[ndisang]

You are seeing this as a privilege issue but I don't think it is. It has to do with the piece of code the user is trying to run.