Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajeshvarun
Starting Member
7 Posts |
 Posted - 2013-08-31 : 01:59:11
|
| Hi all, I have created an user with access to 2 databases. But when I tried to login with that user credentials user got connected but unable to access to the database. But once I have given access on MSDB database user is able to access the desired databases but the same user is able to access all other databases on server. Please suggest me how to cut access to that user from accessing other databases with out effecting his access to his own databases. I have also checked user mapping tab but in that user got access to MSDB and his assigned databases only.Thanks,Varun |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
USER ISSUE