sys.dm_pdw_network_credentials (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database noAzure SQL Data Warehouse yesParallel Data Warehouse

Returns a list of all network credentials stored in the Parallel Data Warehouse 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 Parallel Data Warehouse 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

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