From the course: SQL Server: Security for Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Roles and privileges overview

Roles and privileges overview - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Roles and privileges overview

“

- [Instructor] Once you have a login and a database user, the next thing you need to do is be able to grant roles and privileges to that user. Let's talk about roles and privileges within SQL Server. So we have a couple of different types of roles in SQL Server so we'll talk about first fixed server roles. You may have heard of these before. They've been in SQL Server since it was first introduced and these fixed server roles are really a (mumbles) and we go back to SQL Server being a fork of the original side base database engine. Fixed roles are pre-configured roles that are within the database engine after you install it that grant privileges. These privileges are typically pretty high-level privileges. One of the most common and most abused of these fixed server roles is the sys admin fixed server role which gives any user if his login is a member of that role complete control of the SQL Server instance without any ability to revoke or deny rights from members of this role…

Contents