(Azure Synapse Analytics sp_pdw_remove_network_credentials) sp_pdw_remove_network_credentials (Azure Synapse Analytics)

适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

这会删除存储在中 Azure Synapse AnalyticsAzure Synapse Analytics 用于访问网络文件共享的网络凭据。This removes network credentials stored in Azure Synapse AnalyticsAzure Synapse Analytics to access a network file share. 例如,使用此存储过程删除在 Azure Synapse AnalyticsAzure Synapse Analytics 驻留在自己的网络中的服务器上执行备份和还原操作的权限。For example, use this stored procedure to remove permission for Azure Synapse AnalyticsAzure Synapse Analytics to perform backup and restore operations on a server that resides within your own network.

主题链接图标 Transact-SQL 语法约定 (Transact-SQL)Topic link icon Transact-SQL Syntax Conventions (Transact-SQL)

语法Syntax

-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse  
  
sp_pdw_remove_network_credentials 'target_server_name'  

备注

Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

参数Arguments

"target_server_name"'target_server_name'
指定目标服务器主机名或 IP 地址。Specifies the target server host name or IP address. 将从中删除用于访问此服务器的凭据 Azure Synapse AnalyticsAzure Synapse AnalyticsCredentials to access this server will be removed from Azure Synapse AnalyticsAzure Synapse Analytics. 这不会更改或删除你自己的团队管理的实际目标服务器上的任何权限。This does not change or remove any permissions on the actual target server which is managed by your own team.

target_server_name 定义为 nvarchar (337) 。target_server_name is defined as nvarchar(337).

返回代码值Return Code Values

0(成功)或 1(失败)0 (success) or 1 (failure)

权限Permissions

需要 ALTER SERVER STATE 权限。Requires ALTER SERVER STATE permission.

错误处理Error Handling

如果在控制节点和所有计算节点上删除凭据不成功,则会发生错误。An error occurs if removing credentials does not succeed on the Control node and all Compute nodes.

一般备注General Remarks

此存储过程将从的 NetworkService 帐户中删除网络凭据 Azure Synapse AnalyticsAzure Synapse AnalyticsThis stored procedure removes network credentials from the NetworkService account for Azure Synapse AnalyticsAzure Synapse Analytics. NetworkService 帐户 SQL ServerSQL Server 在控制节点和计算节点上运行 SMP 的每个实例。The NetworkService account runs each instance of SMP SQL ServerSQL Server on the Control node and the Compute nodes. 例如,在运行备份操作时,控制节点和每个计算节点将使用 NetworkService 帐户凭据来访问目标服务器。For example, when a backup operation runs, the Control node and each Compute node will use the NetworkService account credentials to access the target server.

元数据Metadata

若要列出所有凭据并验证是否已删除凭据,请使用 (transact-sql)sys.dm_pdw_network_credentials To list all credentials and to verify the credentials have been removed, use sys.dm_pdw_network_credentials (Transact-SQL).

若要添加凭据,请使用 (Azure Synapse Analytics)sp_pdw_add_network_credentials To add credentials, use sp_pdw_add_network_credentials (Azure Synapse Analytics).

示例:Azure Synapse AnalyticsAzure Synapse Analytics并行数据仓库Parallel Data WarehouseExamples: Azure Synapse AnalyticsAzure Synapse Analytics and 并行数据仓库Parallel Data Warehouse

A.A. 删除用于执行数据库备份的凭据Remove credentials for performing a database backup

下面的示例将删除用于访问 IP 地址为10.192.147.63 的目标服务器的用户名和密码凭据。The following example removes user name and password credentials for accessing the target server which has an IP address of 10.192.147.63.

EXEC sp_pdw_remove_network_credentials '10.192.147.63';