Privileges Needed for Native Object Store | VantageCloud Lake - Setting Access Privileges - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

To access data in the Analytics Database, 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 Example: Controlling Access with an Authorization Object Using User and Password Credentials or Example: Creating an Authorization Object for Azure Service Principals.

    		 GRANT CREATE AUTHORIZATION on user to user;

    For example, issue the grants your user needs. Your users may only need a subset of the following grants, depending on the access they require:

    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;