Action not Granted to Teradata Vantage User | Teradata R Package - 16.20 - Action not Granted to Teradata Vantage User - Teradata R Package

Teradata® R Package User Guide

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2022-05-02
dita:mapPath
qbt1519078127352.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval

The tdplyr package helps you establish a connection to Vantage through the R interface, by accessing the IP address of the Advanced SQL Engine server with the user credentials (namely a username and password) for that server. See Testing Connection to Vantage with Teradata SQL Driver for R for details.

To perform tasks on Vantage, these credentials are not adequate. You must ensure that the Advanced SQL Engine user account has appropriate permissions to perform the desired tasks.

For example, to create a table in the Advanced SQL Engine database requires the user to have CREATE TABLE permission granted in advance by the database administrator.

If a user attempts to perform a task (action) through tdplyr for which user (user) has insufficient permissions, then an error is returned to the user. This error has the general format:

action has not been granted to user

The solution is to contact the database administrator, communicate the database-derived error, and request appropriate permissions for the desired task to the corresponding user account.