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.