Setting Up to Validate Machine Learning Engine Analytic Functions - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage

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 NewSQL 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