To operate and interact with Vantage with tdplyr, the user that is specified in the Testing Connection to Vantage with Teradata SQL Driver for R procedure must have a series of permissions granted. Otherwise, executing tdplyr functions can result in errors on the R client that stem from inadequate database user permissions.
A database user must be granted in advance the following permissions by the Vantage database administrator:
- GRANT EXECUTE FUNCTION ON SYSLIB TO user;
- GRANT CONNECT THROUGH proxyuser TO PERMANENT user WITHOUT ROLE;
- GRANT SELECT ON TD_SERVER_DB.coprocessor TO user;
- GRANT INSERT ON TD_SERVER_DB.coprocessor TO user;
- GRANT EXECUTE FUNCTION ON TD_SERVER_DB.coprocessor TO user;
- GRANT CREATE SERVER ON TD_SERVER_DB TO user;
- GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY TO user;
- GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGINITIATOREXPORT TO user;
- GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGINITIATORIMPORT TO user;
- GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGREMOTEEXPORT TO user;
- GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGREMOTEIMPORT TO user;
- GRANT CTCONTROL ON user TO proxy_user.
The proxyuser is a suitable database proxy user for the analytic functions as determined by the database administrator.