From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Establishing user login roles

Establishing user login roles - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Establishing user login roles

“

- SQL Server provides a number of built-in server and database level roles that uses can be assigned to. These roles represent a pre-configured security principle and by assigning your users to these roles they automatically inherit all of their permissions on the various database securables. At the server level there are nine fixed server-level roles that are available. At the very top is sysadmin or the system administrator. Members of this role can perform any action whatsoever. When you install SQL Server you probably added your own Windows authentication account as the sysadmin for your instance. You might also have enabled the SA account which is a log in account that uses SQL Server authentication and is also automatically assigned to the sysadmin fixed server role. Members of serveradmin can shut down the server and configure system-wide options. Because securityadmins can assign almost any sever-level permission, they should be treated as sysadmins as they will effectively…

Contents