public synonym access privilage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: public synonym access privilage

  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Question public synonym access privilage

    hai guys,
    i have created a user MMS with roles connect, resource& i have some public symonyms through SYSTEM user & now the problem is that this MMS user was not able to aceess these public synonyms. what are the roles/preivilages that are necessary to give it to MMS user to select/update those public synonyms?
    ThannQ

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what errors you get because public can always access public synonyms...

  3. #3
    Join Date
    Aug 2003
    Location
    Dhahran
    Posts
    33
    As pando says there is no issue with accessing public synonyms. They always work. But just because you have made a public synonym does not mean that you have granted all the privileges on that object to PUBLIC - it just means that anyone can reference the object by the synonym name. When they do reference the object they will be checked for their access privileges.

    In this case what do you want MMS to be able to do with the object? Grant him those particular privileges.

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