Grant Role/ Profile Privileges to SYSDBA | Teradata Vantage - 2.2 - Granting Role and Profile Privileges to SYSDBA - 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)

Initially, only DBC has the ability to create roles and profiles.

Grant the ability to create, drop, and administer roles and profiles to SYSDBA. SYSDBA can then grant role and profile privileges to other users. See Teradata Vantageā„¢ - SQL Data Control Language, B035-1149.

  1. Log on as DBC.
  2. Grant administrative privileges for roles to SYSDBA. For example:
    GRANT ROLE TO SYSDBA WITH GRANT OPTION;
  3. Grant administrative privileges for profiles to SYSDBA. For example:
    GRANT PROFILE TO SYSDBA WITH GRANT OPTION;