To work with file management functions, a user must be granted specific permissions and additional permissions on the user's database.
- Permissions to the user.For example, if the user is 'TDAPUSER, the following permissions are required':
- GRANT EXECUTE PROCEDURE ON SYSUIF.INSTALL_FILE TO TDAPUSER;
- GRANT EXECUTE PROCEDURE ON SYSUIF.REPLACE_FILE TO TDAPUSER;
- GRANT EXECUTE PROCEDURE ON SYSUIF.REMOVE_FILE TO TDAPUSER;
- Permissions to the user on the user's database.For example, if the user is 'TDAPUSER' and the database is 'TDAPUSERDB', the following permissions are required:
- GRANT CREATE EXTERNAL PROCEDURE ON TDAPUSERDB TO TDAPUSER;
- GRANT DROP PROCEDURE ON TDAPUSERDB TO TDAPUSER;