sys.dm_cryptographic_provider_sessions (Transact-SQL)
Applies to: SQL Server
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). |
Permissions
Members of the public server role can use sys.dm_cryptographic_provider_sessions to return information about the current connection. To view all cryptographic connections, the CONTROL server permission is required.
See Also
Security Catalog Views (Transact-SQL)
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Encryption Hierarchy
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru