Posts Tagged ‘databses’
HOw can I prevent a user to see all dBs in SQL server thru enterprise manager even he has rights only on 1 db.
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
FOr Expamle i have 7 databses in an SQL server 2000 . and created user “sarfraz” with windows authentication and grant access it to only 1 databse called “northwind” .When safraz open Enterprise manager for SQl seerver he saw a list all databases (Even though he has no rights) . How can I prevent this scenario so that i f a user hae no rights on particular db so That db sould no listed in Enterprise manager ?
Posted in Windows 7 | 
Tags: authentication, databases, databses, DBS, EnterPrise, enterprise manager, Expamle, for, grant access, how, Manager, open enterprise, sarfraz, Server, SQL, sql server 2000, thru, user | 
1 Comment »
