Azure SQL - Create User
Jump to navigation
Jump to search
CREATE LOGIN user1 WITH PASSWORD = 'Password1'; CREATE USER user1 from LOGIN user1; exec sp_addRoleMember 'dbmanager', user1; exec sp_addRoleMember 'loginmanager', user1;
- Check current role
Check current roles
SELECT p.NAME rolename ,m.NAME username FROM sys.database_role_members rm JOIN sys.database_principals p ON rm.role_principal_id = p.principal_id JOIN sys.database_principals m ON rm.member_principal_id = m.principal_id
- Set Firewall for Azure DB server
SELECT * FROM sys.firewall_rules ORDER BY name; SELECT * FROM sys.database_firewall_rules ORDER BY name; EXEC sp_set_database_firewall_rule @name = N'InternaloFirewallRule', @start_ip_address = '0.0.0.0', @end_ip_address = '255.255.255.255'; EXEC sp_delete_database_firewall_rule @name = N'InternaloFirewallRule'