Manage Authorization through Column and Row Level Security
In this lab, you’ll manage authorization of an Azure Dedicated SQL Pool through column and row level security. When you’re finished with this lab, you’ll have experience creating database users and inline table-valued functions, and managing security policy.
Terms and conditions apply.
Lab info
Lab author
Challenge
Create SQL User Accounts
You will create three user accounts and logins that will demonstrate different access capabilities.
Challenge
Prepare Database Tables
You will create two tables to hold data and demonstrate how column- and row-level security are configured.
Challenge
Configure Column Level Security (CLS)
You will grant specific column access to users to restrict them from viewing columns for which they don't have privileges.
Challenge
Configure Row Level Security (RLS)
You will implement filter select statements for various users by creating an inline table-valued function and a security policy for the DimStaffDetailsSecured table.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.
Recommended prerequisites
- Azure Data Studio (ADS)