Returns 1 if the security service is active and 0 if it is not.
is_sec_service_on(security_service_nm)
is the name of the security service.
select is_sec_service_on("unifiedlogin")
Use is_sec_service_on to determine whether a given security service is active during the session.
To find valid names of security services, run this query:
select * from syssecmechs
The result might look something like:
sec_mech_name available_service ------------- -------------------- dce unifiedlogin dce mutualauth dce delegation dce integrity dce confidentiality dce detectreplay dce detectseq
The available_service column displays the security services that are supported by Adaptive Server.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute is_sec_service_on.
Function show_sec_services
