sys.dm_pdw_network_credentials (Transact-SQL)sys.dm_pdw_network_credentials (Transact-SQL)

適用於: 否SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 是平行處理資料倉儲 APPLIES TO: noSQL Server noAzure SQL Database noAzure SQL Data Warehouse yesParallel Data Warehouse

傳回一份所有的網路認證儲存在平行處理資料倉儲Parallel 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_idpdw_node_id intint 與節點相關聯的唯一數值識別碼。Unique numeric id associated with the node.
target_server_nametarget_server_name nvarchar(32)nvarchar(32) 目標伺服器的 IP 位址,平行處理資料倉儲Parallel Data Warehouse會使用使用者名稱和密碼的認證來存取。IP address of the target server that 平行處理資料倉儲Parallel Data Warehouse will access by using the username and password credentials.
userNameusername nvarchar(32)nvarchar(32) 密碼會儲存使用者名稱。Username for which the password is stored.
last_modifiedlast_modified datetimedatetime 修改認證的上次作業的日期時間。Datetime of the last operation that modified the credential.

PermissionsPermissions

需要 VIEW SERVER STATE。Requires VIEW SERVER STATE.

一般備註General Remarks

這個動態管理檢視的索引鍵是pdw_node_id加上target_server_nameThe key for this dynamic management view is pdw_node_id plus target_server_name.

另請參閱See Also

SQL 資料倉儲和平行處理資料倉儲動態管理檢視(Transact SQL)SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)