-
Oracle Errior ORA-04043
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
-
Can you show the grant statements you issued, and can you also post the exact error message reported.
Regards
Jim
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...
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|