|
rm_appcontext()
The
security function
rm_appcontext()
deletes one or all application contexts. rm_appcontext() is a so-called built-in
function,
provided by the
Application Context Facility
(ACF). It can only be executed by
users
with according
privileges.
Users who execute the function without correct privileges receive an error
message and the return value "-1" zurück. Users with correct
privileges receive the return value "0" or the "application context attribute name".
Syntax of the Security Function rm_appcontext()
rm_appcontext("context_name", "attribute_name")
The parameters of the Security Function get_appcontext()
context_name
The parameter "context_name" is a placeholder for a
row,
providing the
"application context name".
The parameter is stored as
char(30)
datatype.
attribute_name
The parameter "attribute_name" is a placeholder for a row providing the
"application context attribute name".
The parameter is stored as
char(30)
datatype.
Example for the Security Function rm_appcontext()
select rm_appcontext("context_name_1", *)
go
-----
0
Deletes all attributes of "context_name_1".
select rm_appcontext(*, *)
go
-----
0
Deletes all contexts including all attributes.
select rm_appcontext("context_name_1", *)
go
Select permission denied on built-in rm_appcontext, database dbid
-----
-1
In this case, the user did not have the correct privileges to execute the function.
An error message is returned, together with the return valule "-1".
See also:
ASE T-SQL - Aggregate Functions,
get_appcontext(),
is_sec_service_on(),
list_appcontext(),
Security Functions,
set_appcontext(),
show_sec_services().
|
