To use the Script Table Operator, certain permissions need to be granted to the users by their Database Administrator, as follows:
Permission to run Script Table Operator:
GRANT EXECUTE FUNCTION ON td_sysfnlib.script TO <username>;
Additional permissions:
GRANT CREATE EXTERNAL PROCEDURE ON <database> TO <username>;
GRANT DROP PROCEDURE ON <database> TO <username>;
GRANT SELECT ON <database> TO <username>;
GRANT EXECUTE ON SYSUIF.DEFAULT_AUTH to <username>;
Permissions to run install_file and remove_file:
GRANT EXECUTE PROCEDURE ON SYSUIF.INSTALL_FILE TO <username>;
GRANT EXECUTE PROCEDURE ON SYSUIF.REPLACE_FILE TO <username>;
GRANT EXECUTE PROCEDURE ON SYSUIF.REMOVE_FILE TO <username>;
Additional permissions needed to run the SCRIPT Table Operator via teradataml, if the user will be working through a <database> other than the <username> database:
GRANT EXECUTE FUNCTION ON td_sysfnlib.script TO <database> WITH GRANT OPTION;
GRANT EXECUTE ON SYSUIF.DEFAULT_AUTH TO <database> WITH GRANT OPTION;