Add User to Azure SQL DB and Assign permissions

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 […]

How to report on current Azure MFA registrations in your organisation

Login to Azure Active Directory. Locate Usage & insights , under MonitoringSelect “Users registerd for Multi-Factor Authentication”  Can also be done in powershell : https://dirteam.com/sander/2020/05/14/todo-optimize-the-azure-multi-factor-authentication-methods-used-throughout-your-organization/https://www.cyberdrain.com/monitoring-with-powershell-monitoring-the-used-mfa-type-for-o365-azure/

Azure Multi-Factor Authentication Server Error

Error that determining the Current Master Multi-Factor Authentication Server. the user interface will closeThings to check Make sure the server can access via IEhttps://pfd.phonefactor.nethttps://pfd2.phonefactor.nethttps://css.phonefactor.net2. Make sure you have […]