ML Engine 分析関数を検証するためのセットアップ | Teradata Vantage - Machine Learning Engine分析関数を検証するためのセットアップ - Teradata Vantage

.logon systemname.your_company.com/dbc

systemnameはプライマリ データベース ノード(そのネットワークでのVantageシステムの名前であり、TDPIDとも呼ばれる)です。

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;

.logoff

.logon sysdba

GRANT SELECT, INSERT, DELETE, UPDATE, TABLE, CHECKPOINT, DUMP, RESTORE
ON Tables_Database TO hal;

.logoff