show_sec_services

Description

Lists the security services that are active for the session.

Syntax

show_sec_services()

Parameters

None.

Examples

Example 1

Shows that the user’s current session is encrypting data and performing replay detection checks:

select show_sec_services()

encryption, replay_detection

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute show_sec_services.

See also

Functions is_sec_service_on