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
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
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