show_sec_services

Lists the security services that are active for the session.

Syntax

show_sec_services()

Example 1 – Shows that the user’s current session is encrypting data and performing replay detection checks:
```
select show_sec_services()
```
```
encryption, replay_detection
```

If no security services are active, show_sec_services returns NULL.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute show_sec_services.