16.10 - Creating the Database Administrator Profile - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
Language
English (United States)

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

  1. Log on to Teradata Database as user DBC.
  2. Create the profile for the database administrator, user DBADMIN, for example:
    CREATE PROFILE DBADM AS
    SPOOL =spool_space 
    TEMPORARY =temp_space 
    ACCOUNT = ’account’
    DEFAULT DATABASE = DBADMIN ;

    where:

    Field Description
    DBADM Required. The name of the database administrator profile.

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

    User DBADMIN is the only member of this profile. Because of space and ownership concerns, you should create one or more separate profiles for other administrative users.
    spool_space Optional. The amount of space available for intermediate query results or formatted answer sets to queries and volatile tables. The system borrows spool space from unused permanent space anywhere in the system.

    Recommendation: Set this value equal to the amount of space in the Spool_Reserve database defined in Working with System-Level Space Allocation.

    temp_space Optional. Required only when you use global temporary tables, volatile tables and other features that require temporary space.

    Recommendation: Specify a value if the database requires use of temporary space. For information, see Database Administration and Database Design.

    account' 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, for example the default account for database administrators or programmers. If necessary, you can add other accounts later using a MODIFY PROFILE statement.

    For more about accounts, see Database Administration.

    DEFAULT DATABASE = DBADMIN Optional. The user or database containing 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, which contains all other databases that the administrator needs to access except DBC tables.