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

Use the SYSDBA administrative user login to perform routine DBA operations such as adding, deleting, and modifying users, databases, passwords, perm, and spool limits.

For SYSDBA, allocate approximately 59% of remaining MaxPerm space, assuming Spool_Reserve is 30%, DBC is 10%, and Crashdumps are 1% of available space. Specify less spool space to SYSDBA than DBC. To avoid accidental propagation of large limits, specify spool at 50% or less of the perm space specified for SYSDBA. See Teradata Vantageā„¢ - Database Administration, B035-1093.

  1. Log on as DBC.
  2. Create user SYSDBA with 23592 GB permanent space, 11800 GB spool, and 0 temporary space. For example:
    CREATE USER SYSDBA FROM DBC AS PERM=23592E9, SPOOL=11800E9, TEMPORARY=0, PASSWORD=password;
  3. Provide SYSDBA with SELECT and EXECUTE access on the DBC database. For example:
    GRANT SELECT,EXECUTE ON DBC TO SYSDBA WITH GRANT OPTION;
  4. Provide SYSDBA with full self-access. For example:
    GRANT ALL ON SYSDBA TO SYSDBA WITH GRANT OPTION;
  5. Provide SYSDBA with SELECT access on database SYS_Calendar. For example:
    GRANT SELECT ON SYS_CALENDAR TO SYSDBA WITH GRANT OPTION;
  6. [Optional] Provide all users with SELECT access on database DBC. For example:
    GRANT SELECT ON DBC TO PUBLIC;
    Because this step enables any user to view all user submitted SQL queries, make sure this access is consistent with corporate security policies.