Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)