Set Up to Validate ML Engine Analytic Functions | Teradata Vantage - 2.2 - Setting Up to Validate Machine Learning Engine Analytic Functions - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

To run analytic functions on Machine Learning Engine you must be logged on as a user that has certain privileges, such as EXECUTE FUNCTION on QGEXECUTEFOREIGNQUERY, CREATE SERVER on td_server_db, and many more.

  1. From a client application (such as BTEQ or Teradata Studio), log on to the Vantage system as DBC. For example:
    .logon systemname.your_company.com/dbc

    where systemname is the primary database node (the name by which the Vantage system is known to the network, also called the TDPID).

  2. Grant the necessary privileges to the user.
    Use the same user that created the tables in Validating Advanced SQL Engine Analytic Functions because this user owns the tables you will query next.
    grant ctcontrol on hal to td_ffe_svc_acct;
    grant connect through td_ffe_svc_acct to permanent hal without role;
    grant execute function on TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY to hal;
    grant execute function on TD_SYSFNLIB.QGINITIATOREXPORT to hal;
    grant execute function on TD_SYSFNLIB.QGINITIATORIMPORT to hal;
    grant execute function on TD_SYSFNLIB.QGREMOTEEXPORT to hal;
    grant execute function on TD_SYSFNLIB.QGREMOTEIMPORT to hal;
    grant create server on td_server_db to hal;
    
    GRANT select ON TD_SERVER_DB.coprocessor TO hal;
    GRANT insert ON TD_SERVER_DB.coprocessor TO hal;
    GRANT execute function on TD_SERVER_DB.coprocessor to hal;
    
    grant create function on hal to hal with grant option;
    grant execute function on hal to hal with grant option;
    
    grant execute function on td_sysfnlib.script to hal;
    grant execute on sysuif.default_auth to hal;
    grant execute procedure on sysuif.install_file to hal;
    grant execute procedure on sysuif.remove_file to hal;
    grant execute procedure on pm.remove_afile to hal;
    grant execute procedure on pm.install_afile to hal;
    grant create external procedure on hal to hal;
    grant select on td_server_db.coprocessor_ddl to hal;
    grant execute function on syslib to hal with grant option;
  3. Log off as DBC:
    .logoff
  4. Log on as SYSDBA:
    .logon sysdba
  5. Grant the user access to Tables_Database. For example:
    GRANT SELECT, INSERT, DELETE, UPDATE, TABLE, CHECKPOINT, DUMP, RESTORE
    ON Tables_Database TO hal;
  6. Log off:
    .logoff