-
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
-
what errors you get because public can always access public synonyms...
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|