Oracle Errior ORA-04043
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?
Can you show the grant statements you issued, and can you also post the exact error message reported.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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...
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width