Skip to content

sys-credentials-transact-sql.md

Latest commit

 

History

History
60 lines (53 loc) · 3.27 KB

sys-credentials-transact-sql.md

File metadata and controls

60 lines (53 loc) · 3.27 KB

title: "sys.credentials (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "02/27/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "sys.credentials"
  • "sys.credentials_TSQL"
  • "credentials_TSQL"
  • "credentials" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.credentials catalog view" ms.assetid: ea48cf80-904a-4273-a950-6d35b1b0a1b6 caps.latest.revision: 33 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

sys.credentials (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]

Returns one row for each server-level credential.

Column name Data type Description
credential_id int ID of the credential. Is unique in the server.
name sysname Name of the credential. Is unique in the server.
credential_identity nvarchar(4000) Name of the identity to use. This will generally be a Windows user. It does not have to be unique.
create_date datetime Time at which the credential was created.
modify_date datetime Time at which the credential was last modified.
target_type nvarchar(100) Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).
target_id int ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

Remarks

For database-level credentials, see sys.database_scoped_credentials.

Permissions

Requires either VIEW ANY DEFINITION permission or ALTER ANY CREDENTIAL permission. In addition, the principal must not be denied VIEW ANY DEFINITION permission.

See Also

sys.database_scoped_credentials
Credentials (Database Engine)
Security Catalog Views (Transact-SQL)
Principals (Database Engine)
CREATE CREDENTIAL (Transact-SQL)