sys-database-scoped-credentials-transact-sql.md

title	sys.database_scoped_credentials (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/27/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse
ms.reviewer
ms.technology	system-objects
ms.topic	conceptual
f1_keywords	sys.database_scoped_credentials sys.database_scoped_credentials_TSQL database_scoped_credentials database_scoped_credentials_TSQL
helpviewer_keywords	sys.database_scoped_credentials catalog view
ms.assetid	68e8aa6b-bcdc-42aa-93d8-d498f724c188
author	VanMSFT
ms.author	vanto
monikerRange	=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_scoped_credentials (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-asdw-xxx-md]

Returns one row for each database scoped credential in the database.

Column name	Data type	Description
name	sysname	Name of the database scoped credential. Is unique in the database.
credential_id	int	ID of the database scoped credential. Is unique in the database.
principal_id	int	ID of the database principal who owns the key.
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 database scoped credential was created.
modify_date	datetime	Time at which the database scoped credential was last modified.
target_type	nvarchar(100)	Type of database scoped credential. Returns NULL for database scoped credentials.
target_id	int	ID of the object that the database scoped credential is mapped to. Returns 0 for database scoped credentials

Permissions

Requires CONTROL permission on the database.

See Also

Credentials (Database Engine)
CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL)
ALTER DATABASE SCOPED CREDENTIAL (Transact-SQL)
DROP DATABASE SCOPED CREDENTIAL (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sys.credentials (Transact-SQL)