Login, Users, and Roles
Learn about the database login, users, and roles.
Server logins are user accounts created in SQL Server and use SQL Server authentication. For example, entering a username and password to log into the SQL Server instance. SQL Server authentication differs from Windows authentication.
These logins are used to grant access to log in to SQL Server but don't necessarily have database access depending on permissions that are assigned. They can also get specific server-level roles that provide certain server permissions within SQL Server.
Server-level roles
Server-level roles determine the types of permissions a user has. Permissions are wrapped into logins by server-level roles.
There are nine types of predefined server-level roles:
- sysadmin: Members can perform any action on the server. It’s essentially the highest level of access.
- serveradmin: Members can change server configurations and shut down the SQL server.
- securityadmin: Members can also reset SQL Server passwords.
- **processadmin ** Members can provide the ability to end