Database administrative roles/profiles | Teradata Vantage - 2.2 - Creating Administrative Roles and Profiles - 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 administrative roles and profiles to provide additional users with administrative privileges. Add a descriptive prefix to each role and profile name. For example:
  • R_role_name
  • P_profile_name
  1. Log on as DBC.
  2. Create the master administrative role R_Master_Admin. For example:
    CREATE ROLE R_Master_Admin;
  3. Provide privileges on DBC to the master administrative role. For example:
    GRANT SELECT, EXECUTE ON DBC TO R_Master_Admin;
  4. Provide privileges on sys_calendar to the master administrative role. For example:
    GRANT SELECT, EXECUTE ON sys_calendar TO R_Master_Admin;
  5. Create the master administrative profile P_Master_Admin. For example:
    CREATE PROFILE P_Master_Admin AS SPOOL=350e9, TEMPORARY=0;