Setting Up a User and 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 use WRITE_NOS, you need the following privileges in Advanced SQL Engine.

  1. Log on to the database as an administrative user with the required privileges to create users and grant privileges.
  2. Create a user, if not already done. For example:
    CREATE USER nos_usr FROM dbc AS PERMANENT=30e8 PASSWORD=user_password;
  3. Grant the necessary privileges to the user. The user may need some or all of the following, depending on which queries the user runs. To run the examples the user needs the following privileges:
    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 FUNCTION ON nos_usr to nos_usr;