Changing User Rights on the QCD - Visual Explain

Changing User Rights on the QCD

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

To grant or revoke user rights

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.

Note: 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:

i Select the Default check box.

i Select the Default check box.

ii Select a user category: Administrator, Power User, or Normal User.

Note: By default, the QCD creator has Administrator rights. For a definition of the user categories, see “Creating a User” on page 107.

Grant or revoke all privileges for selected users:

i Select the All check box.

i Select the All check box.

ii 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:

i Clear the All check box.

i Clear the All check box.

ii 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 an SQL Query” on page 159.

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