User Attributes and Options - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities
 

Table 11: Create User and Modify User Dialog Box Description 

Field or Control

Description

User Name

The name of the new user on the Create User and Clone User dialog boxes.

Note: If modifying a user, the User Name field cannot be changed.

Owner

The user or database name of the parent (owner) of the database that is created or modified. The default owner is the user name associated with the current session.

Note: If modifying a user, the Owner field cannot be changed.

Password

The initial logon password for the user.

Note: Type the complete password. Do not use the Paste command. Do not use the arrow keys or the mouse to navigate in this field.

Temporary

The user is forced to change their password the next time they log on, provided:

  • the user is assigned a profile where the Password - Expire field in set to any number except zero, or
  • the DBC.SysSecDefaults table has been updated.
  • For information on setting the password expiration field, see “Administer Profiles” on page 69.

    For information on the DBC.SysSecDefault table, see SQL Data Definition Language. Under the Modify User command, read about the FOR USER option.

    Perm Space

    The total number of bytes the new or modified user reserves for permanent disk storage.

    The amount specified in this field is deducted from the available permanent disk storage of the user specified in the Owner field.

    Typing the letters K, M or G into this field sets the corresponding option button.

    Spool Space

    The maximum number of bytes of spool space that can be used by any user created within the new or modified user.

    The default value is the same as that of the database owner.

    Typing the letters K, M or G into this field sets the corresponding option button.

    Temp Space

    The maximum number of bytes that can be used by temporary tables created within this database.

    The default value is the same as that of the database owner.

    Typing the letters K, M or G into this field sets the corresponding option button.

    Account

    The user account id associated with the new or modified user.

    Startup String

    Specifies one or more Teradata SQL statements, separated by semicolons, that execute to establish the initial session environment when the user logs on.

    Default Database

    The database to work in by default. Use unqualified object names only in this database; qualify all other objects using the database name.

    The user name specified in the User Name field is used as the default database name if a Default Database name is not specified.

    Profile Name

    Assigns a profile to this user.

    Important: When assigning a profile, the values defined in the profile override the values specified on this dialog box. (The fields that might be overridden have a pale yellow background after a profile is selected.)

    Note: Click the drop down arrow to load the profiles. A fairly long delay occurs if there are many profiles to load. Click the drop down arrow a second time to display the loaded list.

    Default Role

    Selects a default role for the user. This box contains all the roles that the user is assigned membership to, and is disabled if no membership exists.

    Note: Click the drop down arrow to load the roles. A fairly long delay occurs if there are many roles to load. Click the drop down arrow a second time to display the loaded list.

    Default Journal

    The default table for journal images of tables the new or modified user creates.

    By default, the journal table is created in the user space of the new or modified database unless a database and table name is specified.

    A default journal table name must be provided if a journal option is specified, but it need not reside within the user or database space.

    Collation

    Specifies the collation option for the user.

    This option determines the ordering of data characters during comparison operations, and when sorting data in response to select queries that include ORDER BY or WITH…BY clauses.

    If a collation option is not specified, the default is HOST.

    Note: Do not use a collation sequence of EBCDIC as this might cause unpredictable sorting results.

    Before Journal

    Specifies the journaling requirement for “before” change row images as follows:

  • Yes specifies a single journal.
  • No specifies no journal.
  • Dual specifies dual journals.
  • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create User dialog box.

    After Journal

    Specifies the journaling requirement for “after” change row images:

  • Yes specifies a single journal on a different AMP from changed row.
  • No specifies no journal.
  • Dual specifies dual journals.
  • Local specifies a single journal on the same AMP as changed row.
  • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create User dialog box.

    The Local option is only available for non-FallBack tables.

    FallBack

    Specifies that all tables created in this database are created, by default, with fallback protection.

    Time Zone

    Adjust the local time of the user relative to Greenwich Mean Time (GMT).

  • If the field is Null, the user time zone is the same as the system time zone.
  • If the field is set to Local the current system Time Zone is used as this user’s default Time Zone. If the system default is later changed this user keeps the old setting.
  • If an hh:mm value is entered into the field, the user time is adjusted from GMT in the amount specified.
  • Default Date Form

    Specifies the format in which date values are returned to this user. The options are:

  • INTEGER Dates are Imported and Exported as 4 byte INTEGER values. This is the compatibility mode for previous versions of the Teradata Database.
  • ANSI Dates are Imported and Exported as strings; format yyyy‑mm-dd. This is the ANSI defined format.
  • These formats can be overwritten when exporting data in field mode.

    If the field is left blank, the date format is set to the system-wide default.

    Default Character Set

    Specifies the character set that is used for all character columns, in tables that the user creates and for which no specific character set is specified.

    Comment

    Enter any descriptive text.

    Release Lock

    Click to allow a user who is locked out (due to entering invalid passwords) to log into the system again.

    Security Constraint

    Lists all security constraints assigned to the user.

    Add

    Displays the Add Security Constraint dialog box. For details, see “Add Security Constraints to Users or Profiles” on page 77.

    Security value

    Displays the assigned value(s) of the selected constraint.