DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Privilege Issues

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    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
    Posts
    335
    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
    Location
    Rosmalen, Netherlands.
    Posts
    73
    Hi,

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

    Gkramer

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