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

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.