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

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
2.2
Published
January 2021
Language
English (United States)
Last Update
2021-05-08
dita:mapPath
gta1588198788318.ditamap
dita:ditavalPath
dby1605127568110.ditaval
dita:id
B700-4014
Product Category
Analytical Ecosystem
Software
Teradata Vantage

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;