StationX
Start free

Browse › Administer a SQL Database

Can You Configure SQL Server Security?

Advanced

Part of Administer a SQL Database Topic: Data Science

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, you will configure SQL Server Security.

  1. Assign a Fixed Server Role
  2. Create and Assign a User-defined Server Role
  3. Assign Fixed and User-defined Database Roles
  4. Authorize User Access to Objects
  5. Authorize users to execute code
  6. Configure permissions at the Schema Level

Note: Once you begin the lab, you will not be able to pause, save, or exit and then return to your lab. Please ensure that you have set aside enough time to complete the lab before you start.

  • ⏱ About 45 minutes