How can a user be active:show under Activity Monitor, but not be added under Security/Users or DatabaseA/Security/Users?
I view my SQL Server 2008 R2 Express Activity Monitor and I see CompanyNameA\UserNameA as a login using DatabaseA under processes. But I haven't added this user, I have added several users under the domain CompanyNameA but not her, and she doesn't show up under Security/Users or DatabaseA/Security/Users. How can this be? If she's an admin on the network, would that let her login even though I haven't explicitly granted her permission? I have several users created by SQL Server namely: BUILTIN\USERS granted roles db_datareader and db_datawriter on all my databases, guest on DataBaseA granted schema guest but no roles, NTAuthority\NetworkService on the instance granted sysadmin server role NTAuthority\System on the instance granted sysadmin server role This is a user that is OK, I just wondered how she is using the system without being granted access to the database.
ok my bad. Here is my answer at
https://msdn.microsoft.com/en-us/library/ms165636%28v=sql.105%29.aspx During setup of SQL Server Express a login is added for the BUILTIN\Users group. This allows all authenticated users of the computer to access the instance of SQL Server Express as a member of the public role. The BUILTIN\Users login can be safely removed to restrict Database Engine access to computer users who have individual logins or are members of other Windows groups with logins.