We Talk Coding

Home > Databases Information > Databases Knowledge Base > How do you setup a user in MSSQL 2005 with rights to only see certain databases?

How do you setup a user in MSSQL 2005 with rights to only see certain databases?

I'm trying to setup a login user on Microsoft SQL 2005 that will only have rights to see certain databases. I do know how to setup a standard user, but I'm having trouble with the security of that user and not allowing them to see certain databases. This is in the Management Studio.

Public Comments

  1. http://www.tutorials-se.com/sqlserversecurity/User-permissions-29925/ chk this out may it can help u
  2. Do not add a user to a database which this user must not see.
Powered by Yahoo! Answers