Removes a specific application context, or all application contexts. rm_appcontext is a function provided by the Application Context Facility (ACF). For more information about ACF, see "Row Level Access Control," in the System Administration Guide.
rm_appcontext (“context_name”, “attribute_name”)
is a row specifying an application context name. It is saved as datatype char(30).
is a row specifying an application context attribute name. It is saved as datatype char(30).
These examples show how to remove an application context by specifying some or all attributes.
select rm_appcontext("CONTEXT1", "*")
---------- 0
select rm_appcontext("*", "*")
---------- 0
select rm_appcontext("NON_EXISTING_CTX","ATTR")
--------- -1
This example shows the result when a user without appropriate permissions attempts to remove an application context.
select rm_appcontext("CONTEXT1","ATTR2")
----------
-1
This function always returns 0 for success.
All the arguments for this function are required.
SQL92 – Compliance level: Transact-SQL extension.
Permissions depend on the user profile and the application profile, which are stored by ACF.
