User Attributes and Options - Teradata Administrator

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.