This topic has not yet been rated - Rate this topic

sys.dm_cryptographic_provider_sessions (Transact-SQL)

SQL Server 2008

Returns information about open sessions for a cryptographic provider.


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.

Reference

Security Catalog Views (Transact-SQL)

CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)

Encryption Hierarchy

Concepts

Understanding Extensible Key Management (EKM)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD