Privileges Needed for Native Object Store | NOS | Teradata Vantage - Setting Access Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zws1595641486108.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage

To access data in the Advanced SQL Engine, the user must have certain privileges.

  1. Log in as an administrative user and assign privileges depending on the operations the user is performing.
    Privilege Description Command
    CREATE TABLE Allows user to create tables and foreign tables in the database GRANT CREATE TABLE on user to user;
    EXECUTE FUNCTION on READ_NOS Provides access to READ_NOS GRANT EXECUTE FUNCTION on TD_SYSFNLIB.READ_NOS to user;
    EXECUTE FUNCTION on WRITE_NOS Provides access to WRITE_NOS GRANT EXECUTE FUNCTION on TD_SYSFNLIB.WRITE_NOS to user;
    CREATE AUTHORIZATION Allows user to create an authorization object to make an association between the database user and operating system user.

    See Controlling Foreign Table Access with an AUTHORIZATION Object.

    GRANT CREATE AUTHORIZATION on user to user;
    CREATE DATASET Allows user to create a CSV schema for CSV foreign tables that need a user-defined schema. GRANT CREATE DATASET SCHEMA ON SYSUDTLIB TO user;
    CREATE FUNCTION Allows user to create function mapping for hiding credentials.

    GRANT CREATE FUNCTION ON user to user;

    For example, issue the grants your user needs, which may be a subset of the commands below:

    GRANT CREATE TABLE on nos_usr to nos_usr;
    GRANT EXECUTE FUNCTION on TD_SYSFNLIB.READ_NOS to nos_usr;
    GRANT EXECUTE FUNCTION on TD_SYSFNLIB.WRITE_NOS to nos_usr;
    GRANT CREATE AUTHORIZATION on nos_usr to nos_usr;
    GRANT CREATE DATASET SCHEMA ON SYSUDTLIB TO nos_usr;
    GRANT CREATE FUNCTION ON nos_usr to nos_usr;