Granting Privileges to a User - Teradata Database

Granting Privileges to a User

1 Start Teradata Administrator and log on as DBADMIN.

2 From the main screen, click the Preview Mode button to allow future display of generated SQL.

3 Click Tools>Grant/Revoke>Object Rights.

4 In the Grant/Revoke Objects dialog, specify the following:

Use the Database Name, Object Type, and Objects fields to identify the database object which the user will receive privileges on.

In the To/From User tab, select the user who will receive the specified privileges.

In the Normal, Create, or Drop sections, check the privileges the user will receive.

For details, see “Granting Database Privileges to User DBADMIN” on page 35.

5 Click the Grant button. The Query Window displays the generated GRANT statement similar to:

GRANT privilege

ON database_object_name

TO username;

where

The ON clause is based on the values of the Database Name, Object Type, and Objects fields.

The TO clause is based on the user selected from the To/From User tab.

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

7 Close the Query Window and the Grant/Revoke Objects dialog box.

8 Log off Teradata Administrator.