Successfully added
Azure
by Patrik
How to View Existing Firewall Rules in Azure SQL
To check which IP addresses have access to your Azure SQL Database, use the following T-SQL queries:
To list server-level firewall rules:
SELECT * FROM sys.firewall_rules;To list database-level firewall rules:
SELECT * FROM sys.database_firewall_rules;This helps verify which IP ranges currently have access and ensures that no outdated or overly broad rules are active. Regular audits of firewall rules are essential for maintaining data security.
Source: Todd Kitta GitHub – Configure Firewall Settings T-SQL
azure-sql
firewall-rules
audit
database-administration
security
Referenced in:
Comments