Creating Administrative Roles and Profiles - Teradata Vantage

Configuring Teradata Vantageā„¢ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage
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;