Try OpenEdge Now
skip to main content
SQL Development
User Defined Functions : Permissions to create a UDF
 

Permissions to create a UDF

The following guidelines should be adhered to while creating a UDF:
*To create a UDF, a user should have either DBA privileges or RESOURCE privileges.
*To drop a UDF, a user should have either DBA privileges or ownership of that UDF.
*To call a UDF, a user should have EXECUTE privileges or be the owner of the UDF or have DBA privileges.
*The privileges on a UDF can be granted to another user or to public either by the owner of that UDF or by the DBA.
*UDFs are executed based on the privileges of the user who created the UDF. If a user with EXECUTE privilege on a UDF runs it, the privileges of the owner of the UDF are validated for the objects that are accessed by the UDF. This enables a user to execute a UDF successfully even when the user does not have permissions to directly access the objects that are accessed by the UDF, as long as the user has EXECUTE privilege on the UDF.