Lists the security services that are active for the session.
Shows that the user’s current session is encrypting data and performing replay detection checks:
Use show_sec_services to list the security services that are active during the session.
If no security services are active, show_sec_services returns NULL.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute show_sec_services.