Privileges needed for creating and debugging UDFS:
- CREATE FUNCTION
- EXECUTE FUNCTION
Privileges needed for creating and debugging external stored procedures:
- CREATE EXTERNAL PROCEDURE
- EXECUTE PROCEDURE
Privileges needed for debugging UDFs or external stored procedures by a user other than the one who created the routines:
- EXECUTE FUNCTION or EXECUTE PROCEDURE
- DROP FUNCTION or DROP PROCEDURE
Privileges needed for creating and debugging UDMs:
- ALL on SYSUDTLIB
For example, the following statement grants all privileges on SYSUDTLIB to the user named debugger:
grant all on sysudtlib to debugger with grant option;