Oracle Errior ORA-04043
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Errior ORA-04043

  1. #1
    Join Date
    May 2000
    Location
    India
    Posts
    18

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width