Assign Server and Database Roles by Using SQL Server

Skillable
Learn On Demand Pro Series
New

In this lab you will gain hands-on experience with how to assign roles to a server and database. First, you will assign a Fixed Server Role. Next, you will create and assign a User-defined Server Role. Finally, you will assign Fixed and User-defined Database Roles.

Time
30 minutes
Difficulty
Beginner
Share
NEED TO TRAIN YOUR TEAM? LEARN MORE
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

In this lab you will gain hands-on experience with how to assign roles to a server and database. First, you will assign a Fixed Server Role. Next, you will create and assign a User-defined Server Role. Finally, you will assign Fixed and User-defined Database Roles.