Share via


sys.dm_cryptographic_provider_sessions (Transact-SQL)

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

Reference

Security Catalog Views (Transact-SQL)

CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)

Concepts

Extensible Key Management (EKM)

Encryption Hierarchy