How to assign User Connect Permissions to Azure DB

[pastacode lang=”sql” manual=”CREATE%20USER%20%5Bemail%40domain.com%5D%20FROM%20EXTERNAL%20PROVIDER%3B” message=”” highlight=”” provider=”manual”/]

How to find current Roles assigned to Azure DB

[pastacode lang=”sql” manual=”SELECT%20DISTINCT%20pr.principal_id%2C%20pr.name%2C%20pr.type_desc%2C%20%0A%20%20%20%20pr.authentication_type_desc%2C%20pe.state_desc%2C%20pe.permission_name%0AFROM%20sys.database_principals%20AS%20pr%0AJOIN%20sys.database_permissions%20AS%20pe%0A%20%20%20%20ON%20pe.grantee_principal_id%20%3D%20pr.principal_id%3B” message=”” highlight=”” provider=”manual”/]

How to assign User Role to Azure DB

[pastacode lang=”sql” manual=”ALTER%20ROLE%20db_datawrite%20ADD%20MEMBER%20%5Bemail%40domain.com%5D%3B” message=”” highlight=”” provider=”manual”/]