|
is_sec_service_on()
The
security function
is_sec_service_on()
returns "1" if the security service listed in the parameter "security_service_name"
is active. If it is not active, the value "0" is returned.
Syntax of the Security Function is_sec_service_on()
is_sec_service_on("security_service_name")
The parameter of the Security Function is_sec_service_on()
security_service_name
The parameter "security_service_name" is a placeholder for a defined security service. The parameter must be set in quotes. Defined security services can be retrieved with a simple select query from the
system table
syssecmechs.
select * from master..syssecmechs
Moreover, the defined security services can be displayed using the
show_sec_services
function.
Example for the Security Function is_sec_service_on()
select is_sec_service_on("security_service_name")
go
-----
1
In this example the security service is active.
select is_sec_service_on("security_service_name")
go
Msg 4064, Level 16, State 1:
Server '<ASE_SERVER_NAME>', Line 1:
Invalid security service requested.
-----
0
If the security service is not defined, a corresponding error message is returned and the value "0" is displayed.
See also:
ASE T-SQL - Aggregate Functions,
get_appcontext(),
list_appcontext(),
rm_appcontext(),
Security Functions,
set_appcontext(),
show_sec_services().
|
