DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Privilege Issues

    I have a user named ONE grant the table named TABLE to a role named MY_ROLE, and I turn around to grant MY_ROLE to another user named TWO. I also have a public and private synonym for the table named TABLE. I log in as the user named TWO and do a select on the synonym and it's telling me that the table does not exist.

    what am I missing here????

  2. #2
    Join Date
    Nov 2001
    Why do you have public and private synonyms? If it works for user ONE and does not work for user TWO , most likely private synonym for user TWO is not correct or does not exist.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #3
    Join Date
    Apr 2003
    Rosmalen, Netherlands.

    Try to use the schema-name.table-name ( connected as two --> select * from one.table ).


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.