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 |
|
learntsql
524 Posts |
 Posted - 2011-12-12 : 02:33:32
|
| Hi All,I have 3 databases in my instance and i created 3 seperate logins for each database.In user mappings i specified only required databases to accesslike L1-->DB1,L2-->DB2 and L3-->DB3But what i obseved is L1 can also able to access DB2 which is not mapped for L1.Please guide me how to resolve this issue.TIA. |
|
|
kstjacques
Starting Member
8 Posts |
Posted - 2011-12-12 : 11:25:09
|
| Did you accidently assign a server role (such as sysadmin) to L1? You may want to verify just in case. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-12 : 14:19:43
|
| Are there any privileges assigned to the public role in those databases? If so, then any login will have access to those objects.If not, were you expecting that L1 would not be able to see the other databases?Jeff |
|
|
|
learntsql
524 Posts |
Posted - 2011-12-15 : 04:42:20
|
| Thank you jeffw8713,I didnt understand completely but L1 shoud not access any other databases untill i map.Please guide me.TIA |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-15 : 14:01:47
|
| What didn't you understand...In the database DB2, for the public role - are there any privileges granted?Are you concerned that L1 can see the database DB2? Or, are there objects in the database that L1 can access that they shouldn't be able to access?If it is just whether or not the login can see the objects, that is expected and normal.Jeff |
|
|
|
|
|
|
Accessing other than usermaping databases!