UDF and File Access Control Commands | Teradata Vantage - Access Control Commands for Installing, Removing, and Downloading UDFs and Files - Teradata Vantage

Machine Learning User Guide

Product
Teradata Vantage
Release Number
9.01
1.3
Published
August 2020
Language
English (United States)
Last Update
2020-10-02
dita:mapPath
dci1595445931473.ditamap
dita:ditavalPath
dqp1599597541027.ditaval
dita:id
B700-4004
lifecycle
previous
Product Category
Teradata Vantageā„¢
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;