Now the function is installed and usable by all users to whom you’ve granted EXECUTE rights. Test your function by following the steps below to run it:
- Run ACT and log in as an SQL user who has the EXECUTE privilege on the function.
- Invoke the function in a statement such as a SELECT or other data-retrieval statement. Make sure you schema-qualify the function's name, or have its schema in your schema search path. If the function name contains uppercase letters, you must enclose the function name in double quotes.
For an example that shows how to install a function, see Install and Use a Sample Function.