Permissions required to Use Script Table Operator - 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
Published
December 2020
Language
English (United States)
Last Update
2023-06-28
dita:mapPath
rdw1604689631129.ditamap
dita:ditavalPath
hod1606861214058.ditaval
dita:id
B700-4040
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;