Permissions required to Use Script Table Operator - 17.00 - Permissions Required to Use Script Table Operator - Teradata Package for Python - Teradata Vantage

Getting Started Guide for Data Scientists Using Python with Vantage

Product
Teradata Package for Python
Teradata Vantage
Release Number
17.00
Release Date
December 2020
Content Type
Programming Reference
Publication ID
B700-4040-120K
Language
English (United States)
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;