sp_delete_database_firewall_rule (Azure SQL Database)sp_delete_database_firewall_rule (Azure SQL Database)

適用範圍:Applies to: 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database適用範圍:Applies to: 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure SQL Database

從移除資料庫層級防火牆設定 Azure SQL DatabaseAzure SQL DatabaseRemoves database-level firewall setting from your Azure SQL DatabaseAzure SQL Database. 您可以針對 master 資料庫以及的使用者資料庫,設定和刪除資料庫防火牆規則 SQL DatabaseSQL DatabaseDatabase firewall rules can be configured and deleted for the master database, and for user databases on SQL DatabaseSQL Database.

語法Syntax

sp_delete_database_firewall_rule [@name =] [N]'name'
[ ; ]  

引數Arguments

[@name =] [N]'name'
要移除的資料庫層級防火牆設定的名稱。The name of the database-level firewall setting that will be removed. 名稱Nvarchar (128) 沒有預設值。name is nvarchar(128) with no default value. 的 Unicode 識別碼 N 是選擇性的 SQL DatabaseSQL DatabaseThe Unicode identifier N is optional for SQL DatabaseSQL Database.

權限Permissions

只有布建程式所建立的伺服器層級主體登入或指派為系統管理員 Azure Active Directory 主體,才能刪除資料庫層級的防火牆規則。Only the server-level principal login created by the provisioning process or an Azure Active Directory principal assigned as admin can delete database-level firewall rules.

範例Example

下列範例會移除名為的資料庫層級防火牆設定 Example DB Setting 1The following example removes the database-level firewall setting named Example DB Setting 1.

-- Remove database-level firewall setting  
EXECUTE sp_delete_database_firewall_rule N'Example DB Setting 1';  
  

另請參閱See Also

Azure SQL Database 防火牆 Azure SQL Database Firewall
如何: (Azure SQL Database) 設定防火牆設定 How to: Configure Firewall Settings (Azure SQL Database)
sp_set_firewall_rule (Azure SQL Database) sp_set_firewall_rule (Azure SQL Database)
sp_set_database_firewall_rule (Azure SQL Database) sp_set_database_firewall_rule (Azure SQL Database)
sys.database_firewall_rules (Azure SQL Database)sys.database_firewall_rules (Azure SQL Database)