Grant / Revoke System Rights Fields - Teradata Administrator

Field or Control

Description

To/From User

Displays all of the users and databases of the data source that are being worked with.

Select the name of the user or database to grant monitor or system-wide privileges.

To select multiple users, press and hold Ctrl and click on the users.

Role

Displays all of the roles that exist on the data source that are being worked with.

Select the name of the role to grant monitor or system-wide privileges.

To select multiple roles, press and hold Ctrl and click on the roles.

And All Children

Applies to the user or database selected in the To User list. Select to extend the monitor or system-wide privileges to all the children of the selected user or database.

This extension applies to all currently-owned users and databases, and to any that might become owned in the future.

Note: If multiple users are selected, the And All Children option is added only to the first user in the list.

Privileges Check Boxes

Select to specify the system privileges to grant or revoke for the user specified in the To User or From User box.

All

A shortcut to select or clear all the Privileges check boxes.

Grant

Select to grant the selected privileges to the selected To User. It also gives this user the ability to grant the selected privileges to others.

Select to revoke, from the selected To User, the right to grant the selected privileges. To revoke the privileges themselves, issue a second Revoke command without this check box selected.