Microsoft SQL Server 2017 and Azure SQL Database - Permissions Hierarchy

Permissions hierarchy explained well for the below area

SQL Server

• Server Level Permissions
• Database Level Permissions

Azure SQL

• Database Level Permissions - Outside the Database

DOWNLOAD PDF

Source: https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15