From the course: Microsoft SQL Server 2016: Installation and Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manage database roles - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Installation and Administration
Manage database roles
- [Instructor] Adding users to your database security is only the first step in helping to secure the database itself. Once the users have been added, and in this case we have Test User 1 added to our database, they should be assigned to a role. The database roles that are available for each database created on SQL Server, are the accessadmin, backupoperator, datareader, datawriter, admin, denyreader and writer, owner, securityadmin, and public. To get a better understanding of what each of these roles provides, if we drop out to the MSDN Database-Level Roles page and scroll down to the table for the Fixed-Database Roles, we can see a description of each one of the roles and what the members of that role can actually do. So, as an example, the db_datawriter, members of this fixed database role can add, delete, or change data in all user tables. So this table will help you understand the permissions that will be applied to any members of that database role. So let's look at the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.