GRANT EXECUTE on a Function - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

To give a user or group the right to run a function in an Aster instance, an Aster database administrator or the function's owner must use the GRANT EXECUTE command that gives the user the privilege for the specific function:

GRANT EXECUTE [ PRIVILEGE ]
   ON FUNCTION [schemaname.]funcname
   TO { username | GROUP rolename | PUBLIC } [, ...]

There is no support for delegating privilege management, because the WITH GRANT OPTION clause is not supported.