sys.dm_cryptographic_provider_sessions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about open sessions for a cryptographic provider.

Syntax


sys.dm_cryptographic_provider_sessions(session_identifier)  

Arguments

session_identifier
An integer indicating the sessions to be returned.

0 = Current connection only

1 = All cryptographic connections

Table Returned

Column name Data type Description
provider_id int Identification number of the cryptographic provider.
session_handle varbytes(8) Cryptographic session handle.
identity nvarchar(128) Identity used to authenticate with the cryptographic provider.
spid short Session ID SPID of the connection. For more information, see @@SPID (Transact-SQL).

Remarks

The sys.dm_cryptographic_provider_sessions view is visible to the public for the current connection. To view all cryptographic connections, you must have the CONTROL server permission.

See Also

Security Catalog Views (Transact-SQL)
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Encryption Hierarchy