A user with administrative privileges can grant or revoke permissions to install, remove, and download UDFs or files.
Command to Grant User foreign_server_ddl Privileges
GRANT SELECT ON TD_SERVER_DB.coprocessor_ddl TO user WITH GRANT OPTION;
The preceding command must be followed by either the Option 1 or Option 2 commands.
Command to Grant User Privileges to Run Other Stored Procedures Used by UDFs Install/Uninstall Stored Procedures
GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.SCRIPT TO user; GRANT EXECUTE ON SYSUIF.DEFAULT_AUTH TO user; GRANT EXECUTE PROCEDURE ON SYSUIF.INSTALL_FILE TO user; GRANT EXECUTE PROCEDURE ON SYSUIF.REPLACE_FILE TO user; GRANT EXECUTE PROCEDURE ON SYSUIF.REMOVE_FILE TO user; GRANT EXECUTE PROCEDURE ON SQLJ.INSTALL_JAR TO user; GRANT EXECUTE PROCEDURE ON SQLJ.REPLACE_JAR TO user; GRANT EXECUTE PROCEDURE ON SQLJ.REMOVE_JAR TO user; GRANT EXECUTE PROCEDURE ON SQLJ.ALTER_JAVA_PATH TO user; GRANT EXECUTE PROCEDURE ON SYSLIB.EXECUTEFOREIGNSQL TO user;
The preceding commands must be followed by either the Option 1 or Option 2 commands.
Option 1 Commands
These commands grant a user privileges to install, remove, and download in the user private schema.
GRANT EXECUTE PROCEDURE ON pm.install_afunction TO user; GRANT EXECUTE PROCEDURE ON pm.remove_afunction TO user; GRANT EXECUTE PROCEDURE ON pm.install_afile TO user; GRANT EXECUTE PROCEDURE ON pm.remove_afile TO user; GRANT EXECUTE PROCEDURE ON pm.download_afile TO user;
Option 2 Commands
These commands grant a user privileges to install, remove, and download in the public schema. Access to UDFs and files in the public schemas is available to all users without additional grant privileges.
GRANT EXECUTE PROCEDURE ON pm.install_afunction_to_public TO user; GRANT EXECUTE PROCEDURE ON pm.remove_afunction_from_public TO user; GRANT EXECUTE PROCEDURE ON pm.install_afile_to_public TO user; GRANT EXECUTE PROCEDURE ON pm.remove_afile_from_public TO user; GRANT EXECUTE PROCEDURE ON pm.download_afile_from_public TO user;