sys-dm-pdw-network-credentials-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
sys.dm_pdw_network_credentials (Transact-SQL)	sys.dm_pdw_network_credentials (Transact-SQL)	rwestMSFT	randolphwest	03/07/2017	sql	data-warehouse	reference	TSQL	>=aps-pdw-2016

sys.dm_pdw_network_credentials (Transact-SQL)

[!INCLUDE pdw]

Returns a list of all network credentials stored in the [!INCLUDEssPDW] appliance for all target servers. Results are listed for the Control node, and every Compute node.

Column Name	Data Type	Description
pdw_node_id	int	Unique numeric id associated with the node.
target_server_name	nvarchar(32)	IP address of the target server that [!INCLUDEssPDW] will access by using the username and password credentials.
username	nvarchar(32)	Username for which the password is stored.
last_modified	datetime	Datetime of the last operation that modified the credential.

Permissions

Requires VIEW SERVER STATE.

General Remarks

The key for this dynamic management view is pdw_node_id plus target_server_name.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)