list_appcontext

Lists all the attributes of all the contexts in the current session. list_appcontext is provided by the ACF.

Syntax

list_appcontext(["context_name"])

context_name – is an optional argument that names all the application context attributes in the session.

Example 1 – Shows the results when a user with appropriate permissions attempts to list the application contexts:

select list_appcontext ([context_name])

Context Name: (CONTEXT1)
Attribute Name: (ATTR1) Value: (VALUE2)
Context Name: (CONTEXT2)
Attribute Name: (ATTR1) Value: (VALUE1)

Example 2 – Shows the results when a user without appropriate permissions attempts to list the application contexts:
```
select list_appcontext()
```
```
Select permission denied on built-in list_appcontext, database DBID
--------
-1
```

This function returns 0 for success.
Since built-in functions do not return multiple result sets, the client application receives list_appcontext returns as messages.

See also Row-Level Access Control in System Administration Guide for more information on the ACF.

ANSI SQL – Compliance level: Transact-SQL extension

The permission checks for list_appcontext differ based on your granular permissions settings.

Settings	Description
Granular permissions enabled	With granular permissions enabled, you must have `select` permission on list_appcontext to execute the function.
Granular permissions disabled	With granular permissions disabled, you must have `select` permission on list_appcontext or be a user with sa_role to execute the function.