Determines whether a particular security service is enabled. Returns 1 if the service is enabled; otherwise, returns 0.
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, execute:
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.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute is_sec_service_on.
Function show_sec_services
