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

Teradata® Package for R User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
ft:locale
en-US
ft:lastEdition
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
lifecycle
latest
Product Category
Teradata Vantage

The tdplyr package helps you establish a connection to Vantage through the R interface, by accessing the IP address of the Analytics Database 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 Analytics Database user account has appropriate permissions to perform the desired tasks.

For example, to create a table in the 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.