Use this procedure to create a user on Teradata Database.
Connect to Teradata Database before creating a user.
1 Click Tools > Control Center.
The Control Center dialog box appears.
2 Click the Security tab.
3 Click Create a New User.
The New User dialog box appears.
4 In the User Name box, enter the name of the user.
5 In the Owner box, enter the owner of the user.
6 In the Password box, enter the password for the user.
7 In the Perm Space box, define the permanent space:
a Enter a value.
b Click one of the following: KB, MB, or GB.
8 In the Spool Space box, define the spool space:
a Enter a value.
b Select one of the following: KB, MB, or GB.
The default is 0.
9 In the Default Database box, do one of the following:
10 In the Collation box, select a collation type.
11 In the Default Data Form box, select a default data form.
12 In the Default Character Set box, choose a default character set.
13 [Optional] In the Comment box, enter a comment up to 255 characters in length.
14 [Optional] Select Fallback to use fallback protection.
15 In the QCD Name box, enter the name of the QCD in which the user is being given rights.
16 In the User Type box, select a user type.
User Type |
Associated Rights |
Normal User |
Load, view, or delete user’s own plans or workloads only. Note: The Use X‑views for QCD information check box must be selected in the Options dialog box. (See “Setting General Options” on page 88 for more information.) |
Power User |
Load and view plans or workloads inserted by any user. Delete user’s own plans or workloads only. |
Administrator |
Load, view, or delete any plan created by any user. Drop or delete QCD tables. Note: By default, the QCD creator has Administrator privileges. |
17 Click Command to execute an SQL statement.
For more information, see “Executing an SQL Query” on page 155.
18 Click Create to create the user.
Note: Appropriate rights on Teradata Database are required to create a user.