Use grant select on builtin function_name to grant a user permission to use the functions set_appcontext, get_appcontext, list_appcontext, and rm_appcontext.
The syntax is:
grant select on [builtin] function_name
to {name_list | role_list}
Where:
builtin – Used to distinguish between a table and a grantable function with the same name.
function_name – Name of the function for which you are granting permission. Functions for which select permission can be granted are set_appcontext, get_appcontext, list_appcontext, and rm_appcontext.
name_list – List of users’ database names and group names.
role_list – List of the names of system or user-defined roles to which permission is being granted, and cannot be a variable.
This grants select permission on the get_appcontext function to public:
grant select on builtin get_appcontext to public
