Granting Privileges to a User - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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;


  • 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.