16.00 - Granting and Modifying Object-Level Privileges - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
You can grant or modify object-level privileges (database, table, view, or macro-level) to users or roles and column rights to users or roles.
  1. From the Administration perspective, select an object in the Navigator. A list of available objects display in the Object List Viewer.
  2. Click to highlight the object in the Object List Viewer and do one of the following:
    • From the toolbar, click .
    • Right-click an object and select Modify Privileges.
    The Modify Privileges form will display. Depending on the type of object selected, this form will have different tabs (listed below, with applicable object types and description). The functionality of these tabs are similar.
    Tab Applicable Objects Description
    Privileges Granted Database, User Grant privileges on a user or database to the selected grantee.
    Privileges Held Database, User, Role Select objects to grant or revoke privileges from.
    Object Level Privileges All Object Types Grant privileges to selected grantees.
    Column Rights Table, View Grant or modify column rights.
  3. Select either the Privileges Granted, Privileges Held, or Object Level Privileges tabs to grant or modify privileges (the functionality is similar for each of these forms). Repeat as necessary for each available form:
    1. Select a grantee type from the menu. For more information about which privileges are associated with the Public Role, and User grantee type, see SQL Data Control Language. A list of grantees displays under Grantees.
    2. If User is selected, select the user's root database. The Grantees box refreshes and displays a list of grantees associated with the selected root database.
    3. In the Grantees box, select one or more grantees to modify.
    4. Under Display Privileges, select one or more privilege types you would like to grant, and click Display Selected. The states of the privileges in the table are indicated by the Legend. If the privilege in the table is shown in a square box, it indicates that the privilege is set for the grantee (meaning that the user has not changed the state of the privilege). If the privilege in the table is shown in a circle, it indicates that the user has made a change from the original setting to the indicated state. The available privileges display in a table under the Legend. Grantees are listed in the Name column and the remaining columns display the privileges that you can grant.
    5. The Legend shows the different states of a privilege (not all of these states applicable every privilege).
      Privilege State Description
      Not granted Privilege is not granted to the grantee.
      Granted Privilege is granted to the grantee.
      Granted with grant Privilege is granted to the grantee, along with the ability to grant this privilege to others.
      Revokes Privilege is revoked from the grantee.
      Grants Privilege is granted by the grantee.
      Grants with grant Privilege is granted by the grantee, along with the ability to grant this privilege to others.
    6. Under Grant Options, select one or both of the following options:
      Option Description
      All Children Select to extend general access privileges to all the children of the selected user. Only available for the User grantee type.
      With Grant Select to give Public or User the ability to grant privileges to other users. Only available for the Public and User grantee type.
  4. If the selected object type is table or view, then select Column Rights in the left pane to grant or modify column rights (this is not available for other object types).
    1. Select a grantee type from the menu. For more information about which privileges are associated with the Public Role, and User grantee type, see SQL Data Control Language. A list of grantees displays under Grantees.
    2. If User is selected, select the user's root database. The Grantees box refreshes and displays a list of grantees associated with the selected root database.
    3. In the Grantees box, select one or more grantees to modify. For each selected grantee, the names of the table or view columns are listed in the Name column, followed by the Grantees' names if more than one Grantee was selected.
    4. Under Grant Options, select one or both of the following options:
      Option Description
      All Children Select to extend general access privileges to all the children of the selected user. Only available for the User grantee type.
      With Grant Select to give Public or User the ability to grant privileges to other users. Only available for the Public and User grantee type.
  5. Click Commit to execute the DDL that will apply the changes to all modified privileges.
  6. [Optional] Verify the privileges by double-clicking the object in the Object List Viewer to open a tab in the Project Explorer, and click Privileges in the left pane.