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-05-26 : 09:52:27
|
| I have a SQL Server 7 database. On their I have removed the guest account.Normally when we get new users we create a login and give them access to the database via a role.I've just noticed in the transaction log that there are a number of entries that have UID of public. This corresponds to a user that hasn't been given a login on the server but does have a domain account and so is presumably using NT authentication.I thought that if the guest account was removed this couldn't happen, what am I missing here?thankssteveA sarcasm detector, what a great idea. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-26 : 12:38:29
|
| Do you have any NT groups that that person belongs to that have permissions in the database? They're not an NT admin are they?---------------------------EmeraldCityDomains.com |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-27 : 03:04:54
|
| No they're definitely not an NT admin (or if they are they shouldn't be!!) I've just found a group that I'm sure shouldn't be there and have disabled it. Someone will get a good kickingI take it from your response that I have done what I should to prevent this sort of thing (apart from having a group in there)?Many thankssteveA sarcasm detector, what a great idea. |
|
|
|
|
|
|
PUBLIC humiliation