Skip to content

sys-database-firewall-rules-azure-sql-database.md

Latest commit

 

History

History
56 lines (46 loc) · 4.03 KB

sys-database-firewall-rules-azure-sql-database.md

File metadata and controls

56 lines (46 loc) · 4.03 KB
title sys.database_firewall_rules
description Returns information about the database-level firewall settings associated with your Azure SQL Database and SQL database in Fabric.
author VanMSFT
ms.author vanto
ms.reviewer randolphwest
ms.date 07/29/2025
ms.service azure-sql-database
ms.topic reference
f1_keywords
sys.database_firewall_rules_TSQL
database_firewall_rules_TSQL
sys.database_firewall_rules
database_firewall_rules
helpviewer_keywords
database_firewall_rules
sys.database_firewall_rules
dev_langs
TSQL
monikerRange =azuresqldb-current

sys.database_firewall_rules

[!INCLUDEAzure SQL Database FabricSQLDB]

Returns information about the database-level firewall settings associated with your [!INCLUDE ssazure-sqldb] and [!INCLUDE fabric-sqldb]. Database-level firewall settings are useful when using contained database users. For more information, see Contained Database Users - Making Your Database Portable.

The sys.database_firewall_rules view contains the following columns:

Column name Data type Description
id int The identifier of the database-level firewall setting.
name nvarchar(128) The name you chose to describe and distinguish the database-level firewall setting.
start_ip_address varchar(45) The lowest IP address in the range of the database-level firewall setting. IP addresses equal to or greater than this can attempt to connect to the [!INCLUDEssSDS] instance. The lowest possible IP address is 0.0.0.0.
end_ip_address varchar(45) The highest IP address in the range of the firewall setting. IP addresses equal to or less than this can attempt to connect to the [!INCLUDEssSDS] instance. The highest possible IP address is 255.255.255.255.

Note: Azure connection attempts are allowed when both this field and the start_ip_address field equals 0.0.0.0.
create_date datetime UTC date and time when the database-level firewall setting was created.
modify_date datetime UTC date and time when the database-level firewall setting was last modified.

Remarks

To return information about the server-level firewall settings associated with your [!INCLUDE ssazure-sqldb], use sys.firewall_rules (Azure SQL Database).

Permissions

This view is available in the master database and in each user database. Read-only access to this view is available to all users with permission to connect to the database.

See also