Creating User DBADMIN - Analytics Database - Teradata Vantage

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 because multiple people logging as the same administrator prevents the system from recording the actions of different individuals.

1. Log on to the 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 = AdminProfile ];

   DBADMIN

   The name of the database administrator user. You can specify a different username. The examples refer to the database administrator as DBADMIN.

   DBC

   The owner of the space in which you create user DBADMIN.

   perm_space

   The space in bytes that contains all objects that user DBADMIN creates or owns. Because user DBADMIN creates and owns nearly all Vantage 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.

   temporary_password

   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.

   DEFAULT DATABASE = DBADMIN

   [Optional] The user or database that contains the space in which the Analytics Database stores or searches for new or target objects, unless the transaction SQL specifies a different database.

   Recommendation: Specify DBADMIN.

   PROFILE = AdminProfile

   [Optional] The name of the profile for DBADMIN.

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

Related Information