Oracle Errior ORA-04043

[bhas]

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

[jovery]

Can you show the grant statements you issued, and can you also post the exact error message reported.

Regards

[adewri]

are you able to describe the table xyz from user user1.

your error message says

(getting an error "ORA-04043: object CW.cw does not exist"),


where as the table name is xyz...

are you sure you created the synonym the right way ?? or is the synonym name cw for xyz

check the create synonym syntax...