15.10 - Grant / Revoke Object Rights Fields - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K
 

Table 27: Grant/Revoke Objects Dialog Box Description 

Field or Control

Description

Database Name

Specify the database or user to grant or revoke privileges.

Note: The UDT Usage check box is only available when the SYSUDTLIB database is selected.

Object Type

Specify the type of object to grant privileges.

When one of the Types is selected, the check boxes for the privileges that are available for that type of object are activated.

If any type except Database is chosen, the Object list displays all the objects of the selected type contained in the selected database.

Object

Displays all of the database object names of the type specified in the Object Type box for the user or database selected in the Database field.

Select the name of the object to grant or revoke general access privileges.

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 general access privileges.

To select multiple users, press and hold Ctrl and click 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 general access 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 general access 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.

Public

Select to extend the general access or column privileges to all users and databases on the currently selected database.

This applies to all currently defined users and databases, and to any that might be defined in the future.

Normal

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

Create

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

Drop

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

All

Selects all available rights for those whose check boxes are active in the Normal, Create, and Drop areas of the dialog box.

Dictionary

Selects all available dictionary-related rights.

  • Create – selects all available create object rights.
  • Drop – selects all available drop object rights.
  • Access

    Selects all available data access rights.

    All But

    Select to either grant or revoke all of the privileges whose check boxes are active except those that have been selected.

    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.