7.00.02 - Setting Permissions to Allow Users to Run Functions - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
zuk1466006200888
In the following procedure, schema is the schema where the functions are installed (typically PUBLIC).
  1. Verify that you have the privilege to grant the EXECUTE privilege on the installed functions.
  2. Grant the EXECUTE privilege to either:
    • Each function in schema. For example:

      GRANT EXECUTE ON FUNCTION PUBLIC.Path_Start TO PUBLIC;

    • Each user for each function that he or she must run. For example:

      GRANT EXECUTE ON FUNCTION PUBLIC.Path_Start TO beehive;

  3. If schema is not PUBLIC, grant each function user these additional privileges on schema:
    • READ
    • INSTALL
    • CREATE TABLE
    • TRUNCATE TABLE