I Created one user and i assingned that user to one database, My DB Server have some more DB also, if i trying to login in SQL Server 2008 Mgmt studio.
The following Exception is throwing when i expand the database for every database.
The server principal "sUser" is not able to access the database "OtherDB" under the current security context. (.Net SqlClient Data Provider)
Note :It is populating the database when added the user to all other database by ddl deny roles.
If i a user is created and assigned to some specific Database,When we login in Mgmt studio, it should display only the databases which is assigned to that user.
Please suggest howe to achieve the above Behaviour.