GRANT INSTALL FILE and GRANT CREATE FUNCTION on a Schema - 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 install files and create functions in an Aster instance, a database administrator must use one of GRANT commands that gives the user privileges in the context of a schema:

GRANT { INSTALL FILE | CREATE FUNCTION } [, ...] [ PRIVILEGE ]
   ON SCHEMA schemaname [, ...]
   TO { username | GROUP rolename | PUBLIC } [, ...]

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