plsql.dbms_session.set_identifier(current_user) results in an "ORA-00942: table or view does not exist" error.

[Kerry DH]

In our test and UAT environments the plsql.dbms_session.set_identifier works great.  In our new production environment we get the noted error.  Any debug/research suggestions to identify the issue would be appreciated.  The DBA granted us Execute permissions on the DBMS_SESSION package.

[Kerry DH]

We were able to resolve the issue.  The security context used to connect to the database needs select permissions on the all_users table.