Microsoft · DP-300
Permissions and access troubleshooting
DP-300 · Lesson 8 of 22 · 1:06:08
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: securables and permission scopes from the server down to objects, GRANT, DENY, and REVOKE, least privilege with roles, schema-level grants, and stored procedures, managing permissions in SQL Server Management Studio and T-SQL, and troubleshooting access by error number (40615, 18456, and 229). Includes three original practice questions.
Preview the topics
- Contoso’s reporting team needs to read every table in the Sales schema, including tables added next month, but nothing else in the database. What’s the least privilege approach?
- A Contoso analyst belongs to a role that was granted SELECT on Payroll. The security team wants this one analyst blocked from Payroll, while the rest of the role keeps access. What should it run?
- A Contoso user gets error 40615 when connecting to Azure SQL Database from a new office, while colleagues elsewhere connect fine. What should the administrator check first?