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.…Including the sys admin role,…