1.0 - Access Control of Teradata ML Engine Analytic Functions - Teradata Vantage

Teradata® Vantage User Guide

Product
Teradata Vantage
Release Number
1.0
Published
January 2019
Language
English (United States)
Last Update
2020-03-11
dita:mapPath
hfp1506029122470.ditamap
dita:ditavalPath
hfp1506029122470.ditaval
A user with administrative privileges can grant or revoke access control of Teradata ML Engine analytic functions. To grant access of an analytic function installed in syslib database to a user:
GRANT EXECUTE FUNCTION ON SYSLIB.function_name TO user;
To revoke access to an analytic function installed in syslib database from a user:
REVOKE EXECUTE FUNCTION ON SYSLIB.function_name FROM user;
To control access of Teradata ML Engine analytic functions, you need to grant or revoke permission on the foreign server:
GRANT EXECUTE FUNCTION on TD_SERVER_DB.coprocessor TO user;
REVOKE EXECUTE FUNCTION ON TD_SERVER_DB.coprocessor FROM user;