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.
- Log on as DBC.
- 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;
- Provide SYSDBA with SELECT and EXECUTE access on the DBC database. For example:
GRANT SELECT,EXECUTE ON DBC TO SYSDBA WITH GRANT OPTION;
- Provide SYSDBA with full self-access. For example:
GRANT ALL ON SYSDBA TO SYSDBA WITH GRANT OPTION;
- Provide SYSDBA with SELECT access on database SYS_Calendar. For example:
GRANT SELECT ON SYS_CALENDAR TO SYSDBA WITH GRANT OPTION;
- [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.