is_sec_service

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

Syntax

is_sec_service_on(security_service_nm)

Parameters

security_service_nm – is the name of the security service.

Examples

Example 1 – Indicates whether unifiedlogin is active:
```
select is_sec_service_on("unifiedlogin")
```

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.