New answers tagged mssql-maintenance
Database logins and database users are different. Basically a login is granted permissions the server, a user is granted permissions to database. Logins are mapped to databases. My guess the reason you have users in a database that aren't mapped to logins is that you've restored a database from another SQL Server and not copied the logins across. There ...
Top 50 recent answers are included