Modify Administrative User SYSDBA | Teradata Vantage - 2.2 - Modifying the SYSDBA User - 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)

Assign the administrative role and profile to the SYSDBA user. You cannot specify WITH GRANT OPTION for roles. You specify WITH ADMIN OPTION to enable SYSDBA to change permissions in the role and determine to whom to grant or revoke the role. Omit this option for non-administrative users.

  1. Log on as DBC.
  2. Grant the master administrative role to SYSDBA. For example:
    GRANT R_Master_Admin TO SYSDBA WITH ADMIN OPTION;
    
  3. Modify the SYSDBA administrative user. For example:
    MODIFY USER SYSDBA AS DEFAULT ROLE=R_Master_Admin, PROFILE=P_Master_Admin;
  4. Log off.