Create general user roles | Teradata Vantage - 2.2 - Creating General User Roles - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

Create user roles for general, update, and batch operations.

  1. Log on as SYSDBA.
  2. Create the general user role. For example:
    CREATE ROLE R_General_User;
  3. Grant the necessary privileges to the general user role. For example:
    GRANT SELECT, EXECUTE ON General_Views TO R_General_User;
  4. Create the update user role. For example:
    CREATE ROLE R_Update_User;
  5. Grant the necessary privileges on the General_Views and Update_Views databases to the update user role. For example:
    GRANT SELECT, EXECUTE ON General_Views TO R_Update_User;
    GRANT SELECT, EXECUTE, INSERT, DELETE, UPDATE ON Update_Views 
    TO R_Update_User;
  6. Create the batch user role. For example:
    CREATE ROLE R_Batch_User;
  7. Grant the necessary privileges to the batch user role. For example:
    GRANT SELECT, INSERT, DELETE, UPDATE, TABLE, CHECKPOINT, DUMP, RESTORE
    ON Tables_Database TO R_Batch_User;