is_sec_service_on

Determines whether a particular security service is active during the session.

Syntax

is_sec_service_on(security_service_nm)

Parameters

Examples

Usage

  • Returns 1 if the service is enabled; otherwise, returns 0.

  • 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 the SAP ASE server.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute is_sec_service_on.

Related reference
show_sec_services