Andreas Wolter • 3/16/2021

Security: Delegation of Authority

This article, part of a series on SQL Server security, details the concept of delegation of authority. It explains delegation at the identity level (e.g., Runas, sudo) and authorization level (RBAC), linking it to principles like Least Privilege. It covers practical implementations using OAuth On-Behalf-Of flows in Azure AD and SQL Server-specific methods like GRANT WITH GRANT OPTION and managed identities for user provisioning.

0 comments

#oauth #Database Security #Delegation