title
sys.database_scoped_credentials (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/27/2017
ms.prod
sql-non-specified
ms.reviewer
ms.suite
ms.technology
ms.tgt_pltfrm
ms.topic
article
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
caps.latest.revision
2
author
BYHAM
ms.author
rickbyh
manager
jhubbard
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
credential_id
int ID of the database scoped credential. Is unique in the database.
name
sysname Name of the database scoped credential. Is unique in the database.
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
Requires CONTROL permission on the database.
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)