Database roles consolidate user accounts and make security administration at the database level much easier by applying permissions at the role level. Learn how to effectively use database roles to consolidate your database security permissions.
- [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 datawriter role…that we just took a look at.…
Author
Gerry O'Brien
Released
11/9/2016This course is also ideal for anybody preparing for the Administering a SQL Database Infrastructure (70-764) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.
- Installation and configuration considerations
- Data storage strategies
- Configuring database instances
- Performance considerations
- Security considerations
- Managing roles and users
- Managing data
- High-availability options
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 7s
-
-
1. Installation and Configuration
-
Database storage strategies2m 53s
-
Install SQL Server7m 32s
-
Setting up the database4m 5s
-
2. Database Instances
-
Configure linked servers5m 38s
-
3. Performance Considerations
-
Using the profiler5m 41s
-
Auditing the database7m 4s
-
Resource governor5m 16s
-
4. Security
-
Manage roles3m 52s
-
Manage server logins4m 53s
-
Manage database users3m 36s
-
Manage database roles2m 28s
-
Implement server permissions4m 22s
-
Logon triggers4m 17s
-
-
5. Managing Data
-
Backup demonstration5m 26s
-
Moving database files4m 41s
-
Ensure data integrity5m 43s
-
6. High Availability Options
-
Database replication9m 36s
-
Log shipping5m 54s
-
Database mirroring2m 16s
-
Always On2m 32s
-
-
Conclusion
-
Next steps53s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Manage database roles