February 4, 2011 at 1:52 am
Hi,
I have a user connecting to our server using SSMS 2008. I want to limit him to only seeing a single database in the tree view, does anyone know if this is possible without him being dbo_owner of said database?
Also if possible, I would like to 'hide' the Security, Server Objects, Replication, Management and SQL Server Agent folders from this user, is this possible?
thanks in advance 😀
February 4, 2011 at 2:09 am
while creating the login, give the default database name as the one you want the user need to be connected. And also make sure you give the public access on that perticular database in database role.
Theu user will be able to see the default folders in SSMS but will not be able to see within those folder untill u modify the permission
----------
Ashish
April 12, 2011 at 7:24 pm
Yes this is completely possible on SQL 2005 and newer:
To limit visibility to database metadata, execute this code DENY VIEW ANY DATABASE TO [MySQLLogingUser]. After this permission is denied, a login can see only metadata for master, tempdb, and databases that the login owns
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply