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 |
|
doninwales
Starting Member
1 Post |
 Posted - 2013-02-25 : 11:34:20
|
| I have recently inherited a SQL Instance containing a number of databases.These databases contain a user account called 'NT AUTHORITY\ANONYMOUS LOGON' and this user account is granted a specific select permission on a specific user table.(The public role has also been assigned various select privileges to various tables, so presumably the 'NT AUTHORITY\ANONYMOUS LOGON' user account also has these privileges.But I don't understand what this user account is......Who uses it?Who is able to connect to the database with this user account?(There is also a server login called 'NT AUTHORITY\ANONYMOUS LOGON' which is mapped to the equivalent account in each database.I've done an internet search and come across numerous posts related to error messages for "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."But I want to take one step back and find out why such a user account is needed in the first place?Any thoughts? |
|
|
|
|
|
What is user account 'NT AUTHORITY\ANONYMOUS LOGON