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

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.