|
-
Originally posted by tpereira
I have 10 user and 250 tables. I have to create 2500 synonym. This solution don’t solve my problem.
I need other solution that don’t use synonym.
What Jim meant was create public synonyms which is accessible to all. Additionally create a role, grant select on user1's tables to that role and grant that role to the other 10 users.
Last edited by adewri; 06-15-2005 at 08:03 AM.
Amar
"There is a difference between knowing the path and walking the path."
 
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
|
Reply With Quote