Changing User Rights on the QCD

Teradata Visual Explain User Guide

Teradata Tools and Utilities
Visual Explain
User Guide

Use the Control Center to grant or revoke specific user rights on the QCD.

Connect to Teradata Database before changing user rights.

  1. From the menu bar, click Tools > Control Center. The Control Center dialog box appears.
  2. Click the Security tab
  3. Click Grant/Revoke privileges on QCD.

    The Change Privileges dialog box appears.

  4. Select one of the following:
    • Grant, to give the user additional rights.

    • Revoke, to take away user rights.

  5. In the QCD Name box, do one of the following:
    • Enter the name of the QCD.

    • Click List QCDs to display all QCDs on the current server.

      The QCDs are listed under QCDs.

  6. Under Users, select one or more users.
    To select more than one user, press Ctrl while making selections.
  7. Do one of the following:
    • To define the user category for the users listed for the specified QCD:
      1. Select the Default check box.
      2. Select a user category: Administrator, Power User, or Normal User.
        By default, the QCD creator has Administrator rights. For a definition of the user categories, see Creating a User.
    • Grant or revoke all privileges for selected users:
      1. Select the All check box.
      2. In the Object Type box, select table, view or macro to grant or revoke privileges for tables, views, or macros.
    • Grant or revoke specific privileges for selected users:
      1. Clear the All check box.
      2. Select the check boxes for the appropriate individual privileges.
  8. Click OK to change the privileges.
  9. [Optional] Click Command, to execute an SQL statement.

    For more information, see Executing a SQL Query.

  10. Click Cancel to stop changing privileges and return to the Control Center dialog box.