Map users to logins
“Why can’t I login after the database restore?” As a DBA, this is one of the questions I get most.
Posts in Category ‘Permissions’
Deny updates on a table but allow inserts
Sometimes it is nessesary to deny updates on a table, but allow inserts. This is the case when the history must never be changed, for instance in a table with accounting data. This can be done in two different ways. … Read more →
List SQL server roles by users
SQL Server roles can be used to give users server wide privileges. The server roles are sysadmin, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator and bulkadmin. The mapping between users and server roles can be found in the system view sys.server_role_members. … Read more →
A replacement for syslogins
The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up until 2012 for backwards compability only. So what is the replacement of sys.syslogins? As it turns out, there is no exact match in SQL … Read more →
Changing the database owner
When a database is created, the logged in user is set as the database owner as default. Often, this user account is a physical person and he or she may get more permissions in the database than intended. Normally, a … Read more →