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 |
|
iamsmahd
Yak Posting Veteran
55 Posts |
 Posted - 2006-07-02 : 02:56:50
|
| hi all.I'm confused of understanding login, user and roles in SQL server.I have installed SQLserver 2000 on my computer recently....it uses "windows authentication".I created a new login sm\ba (ba is one of the accounts of my pc)and got access to it only for northwind DB. but when I log on by "ba", and run sqlserver, i can simply see and maipulate data in pubs DB!!why is that? sonia |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-02 : 10:00:49
|
| what are the permissions you provided for the ba user?--------------------keeping it simple... |
 |
|
|
iamsmahd
Yak Posting Veteran
55 Posts |
Posted - 2006-07-03 : 01:26:00
|
| in DataBase Role tab, I just checked "northwind" DB with defalut permissions (public)sonia |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-03 : 02:05:37
|
| is the guest account activated in the pubs database?--------------------keeping it simple... |
|
|
|
iamsmahd
Yak Posting Veteran
55 Posts |
Posted - 2006-07-04 : 01:17:41
|
| jen,As you had said correctly, the guest account was active in pubs Db. but, in my computer it wa disabled.....when I delete it from pubs's users, every thing was in right manner....Thank you very very muchsonia |
|
|
|
|
|
|
LOGIN, USER, ROLE