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.

Predefined roles in SQL Server

Predefined roles in SQL Server - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Predefined roles in SQL Server

“

- [Instructor] SQL Server ships with a number of predefined roles, both at the server level and at the database level. While these aren't the best way to grant security, especially if you're custom developing an application, it's important that you're aware of them, especially if you're a database administrator. As a developer, you probably want to avoid them and use your own custom roles, but let's talk about what some of these predefined roles are. SQL Server provides server-level roles to manage permissions on a server. These roles are security principals that group other security principals. And these roles are always server-wide. So if we think of roles, they're kind of like groups in windows. And we have fixed roles like sysadmin, dbcreator, ddladmin that are all created at the server level. You generally want to avoid assigning these to end users, especially of an application just because in an environment sometimes you share it. You have multiple databases on a server, and…

Contents