Creating the DBADM Profile - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Creating the DBADM Profile

Profiles determine certain system resources available to member users, and can also set password control parameters.

1 From an administrative client, log on to Teradata Administrator as user DBC.

2 Create the profile for the database administrator, user DBADMIN:

a From the menu, click Tools>Create>Profile.

b Specify values for the following fields and controls:

Note: Do not enter values at this time for fields not listed.




Profile Name

Required. The name of the database administrator profile.

Administrative procedures in this publication use the name DBADM for the administrator profile.

Note: User DBADMIN will be the only member of this profile. Because of space and ownership concerns, you must create a separate profile for other administrative users.

On the General tab...


Optional. An account string defines the following characteristics for profile member sessions in the database:

  • Session priority
  • Account ID (to assign charges for system time and resources)
  • Date stamp
  • Time stamp
  • Recommendation: Define at least one account string per profile. If necessary, you can add an account string later using a MODIFY PROFILE statement.

    For more about accounts, see Chapter 1: “Setting Up Your Administrative Environment: All DBAs.”


    Required. The temporary password for DBADMIN.

    Recommendation: Create a simple temporary password. Each user is prompted to change the temporary password to a permanent, private password upon first logon to the database.

    Spool Space

    Optional. The spool space specification is only a limit to the amount of space available for intermediate query results or formatted answer sets to queries and volatile tables. The system borrows spool space for a user from unused permanent space anywhere in the system.

    Recommendation: Set this value equal to the amount of space in the Spool_Reserve database.

    Temporary Space

    Not applicable. Required only when using global temporary tables and other advanced features.

    Recommendation: Temporary space specification is not normally needed. Specification of temporary space requires that you develop a strategy for use of the advanced features that need temporary space. If necessary, you can add a temporary space specification later with a MODIFY USER statement.


    Optional. Use this space to describe the profile or note contingencies.

    On the Password tab...


    Required. The number in days until a password expires. Set this value to a positive, non-zero number to cause passwords to expire.

    Recommendation: 90 days is a common password expiration interval.

    Other password controls


    Recommendation: Set other password controls globally by updating DBC.SysSecDefaults if required by your site security policy.

    Note: Be sure to review the default password control values to determine whether they conform to your site security requirements.

    For information on the default password control values and how to change them, see Chapter 6: “Managing Database Passwords,” in Security Administration.

    c Do not use the Users in Profile dialog box. You can specify profile membership in “Creating User DBADMIN.”

    d Click the Create button to create the profile. The Query Window displays a generated CREATE PROFILE statement similar to the following:

    ACCOUNT=('$H-DBC-MANAGER',' account__str2',' account_str3')

    e In the Query Window, click the Run Query button . A Query Complete message appears in the bottom left corner of the main window when the query executes.

    f Close the Query Window and the Create Profile dialog box.

    Reference Information


    For step...

    Information on...

    Is available in...


    setting up user accounts

    “Creating User Accounts” on page 106.

    the default password control values and how to change them

    Security Administration