Use the Control Center to grant or revoke specific user rights on the QCD.
Connect to Teradata Database before changing user rights.
- From the menu bar, click The .Control Center dialog box appears.
- Click the Security tab
-
Click Grant/Revoke privileges on QCD.
The Change Privileges dialog box appears.
-
Select one of the following:
-
Grant, to give the user additional rights.
-
Revoke, to take away user rights.
-
-
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.
-
-
Under Users, select one or more users.
To select more than one user, press Ctrl while making selections.
-
Do one of the following:
-
To define the user category for the users listed for the specified QCD:
- Select the Default check box.
- 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:
- Select the All check box.
- 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:
- Clear the All check box.
- Select the check boxes for the appropriate individual privileges.
-
- Click OK to change the privileges.
-
[Optional] Click Command, to execute an SQL statement.
For more information, see Executing a SQL Query.
- Click Cancel to stop changing privileges and return to the Control Center dialog box.