Is there a way to Restricting what databases a user can see in SQL Management Studio.....
What am doing is in SSMS, i create a new user called "Mike" and assign him db_owner, sysadmin and security admin rights. Then he logs into the SSMS with his credentials and creates few databases for his own need
Now, i create a new user again called "Sam" and assign him with the same permission as "Mike". He also creates few databases of his need in the same SQL instances where "Mike" has created databases
Now, i want to restrict "Mike" to see the databases created by "SAM" and vice versa. So, is there a way where ican provision my SQL environment so that databases are not seen in the Instance tree when they connect to the same instance and they see only their databases?
- Edited by Pallav S. Srivastav Thursday, January 26, 2012 4:05 PM