16.10 - Creating User DBADMIN - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

Use the following procedure to create the principal database administrator, DBADMIN. For sites that require multiple database administrators, create lower level administrative users who log on as individuals. Do not allow multiple users to log on as DBADMIN, which prevents the system from logging the actions of individuals.

  1. Log on to Teradata Database as user DBC.
  2. Create the database administrator:
    CREATE USER DBADMIN FROM DBC
    AS PERM =  perm_space 
    PASSWORD =  "temporary_password" 
    DEFAULT DATABASE = DBADMIN
    PROFILE = DBADM ;

    where:

    Field Description
    DBADMIN Required. The name of the database administrator user. You can specify a different username, but all examples in this chapter refer to the database administrator as DBADMIN.
    DBC The owner of the space in which you create user DBADMIN.
    "temporary_password" Required. The temporary password for DBADMIN.

    Recommendation: Use any simple password that follows the default system password controls and site policy. Each user is prompted to change the temporary password to a permanent, private password at first logon.

    perm_space Required. The space in bytes that contains all objects that user DBADMIN creates or owns. Because user DBADMIN creates and owns nearly all Teradata databases and tables, you should assign it the majority of space on the system.

    Recommendation: Specify approximately 60% of available system (DBC) space. For information on how to determine DBC space, see Creating the Spool Space Reserve.

    DEFAULT DATABASE = DBADMIN Optional. The user or database that contains the space in which the Teradata Database stores or searches for new or target objects, unless the transaction SQL specifies a different database.

    Recommendation: Specify DBADMIN.

    PROFILE = DBADM Optional. The name of the profile for DBADMIN.

    Recommendation: Enter DBADM, the profile you created for user DBADMIN in Creating the Database Administrator Profile.

Related Information

Information on... Is available in...
Syntax and options for the CREATE USER statement SQL Data Definition Language.
Guidelines for determining administrator space requirements and long term managing of space Database Administration.
Default password control values and how to change them Managing Database Passwords.