Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)