Oracle Database Discussions

Oracle 11.1.0.7.0 running on AIX

This is crazy I don't know why it is happening or even how it is happening but when I grant a role to a user they still cannot select from the granted tables & views.


CREATE ROLE RETROMAN_USERS NOT IDENTIFIED
/

GRANT SELECT ON YBP.DDA_STATUS_CODES TO RETROMAN_USERS
/
GRANT SELECT ON YBP.DEMAND_DRIVEN_ACTIVITY TO RETROMAN_USERS
/
GRANT SELECT ON YBP.V_DDA_STATUS_CODES TO RETROMAN_USERS
/
GRANT SELECT ON YBP.V_DEMAND_DRIVEN_ACTIVITY TO RETROMAN_USERS
/
GRANT RETROMAN_USERS TO SABEL WITH ADMIN OPTION
/
GRANT RETROMAN_USERS TO CKING
/
GRANT RETROMAN_USERS TO FCROWELL
/
GRANT RETROMAN_USERS TO HCAMPBELL
/
GRANT RETROMAN_USERS TO LJOHNSON
/
GRANT RETROMAN_USERS TO RWILLIAMS
/
GRANT RETROMAN_USERS TO LMONTCALM


When I try to Select * from ybp.Demand_Driven_Activity as hcampbell I get a "table or view does not exist" error. where other users can get results using the same query. Any ideas? I am completely out of them. I am not a DBA and our company doesn't employ a DBA - scary huh. Any help would be greatly appreciated.

Scott