Hi,

I have created a table xyz under CW user and a role cw_updater. I created a public synonym and granted the SELECT,INSERT,UPDATE and DELETE privileges on this to cw_updater role. Another user user1 is unable to access this table (getting an error "ORA-04043: object CW.cw does not exist"), even though cw_updater role has been set as default role to this user. But if I grant the SELECT,INSERT,UPDATE and DELETE privileges to user1 directly, I am getting the above error. What could be the reason for this error?


Thanks
Bhaskar