Compare the privileges of USERA and USERB in user_tab_privs and user_sys_privs tables and see if something is missing for USERB. USERB needs SELECT ANY TABLE system privilege to select from another user's schema.

[Edited by kris109 on 02-19-2002 at 04:36 PM]