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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-02-25 : 10:20:33
|
| I'm confused.My users access our SQL Server 7 via Windows Authentication. I set the windows accounts up on the server and assign them access rights by putting them into the appropriate groups.My understanding was that if I did this then the only way anyone could access the data was via the guest account.In this case, the guest account has been deleted. YET and I'm sure you could see this coming, users with windows accounts who haven't been assigned groups or rights on the server can still access the data.What's going on? This opens up a real can of worms for me as I thought I understood this but I have clearly missed something fundamental.thankssteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-02-25 : 10:30:18
|
| Almost sounds like you have a "public" granted.JimUsers <> Logic |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-02-28 : 05:35:33
|
| I think I have this sussed now. There is an NT group (which this user will be part of) that is setup as a login on the server. I presume this was giving here the authentication she needed.This NT group was originally added when the system was first setup just to make sure that users could access the system. Now I know a little more about SQL Server I have a feeling that it isn't actually required.What might I need to take into account before deleting it? I will script it first so that I can restore it if I need to.thankssteveAnd how is education supposed to make me feel smarter? Besides, every time I learn something new, it pushes some old stuff out of my brain. |
|
|
|
|
|
|
Don't Panic