Grant and Modify Object-Level Privileges | Teradata Studio - Granting and Modifying Object-Level Privileges - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
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. Right-click the object in the Object List Viewer and select Modify Privileges.
    Depending on the type of object selected, the Modify Privileges form has 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.
  2. Select either the Privileges Granted, Privileges Held, or Object Level Privileges tabs to grant or modify privileges. 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 Teradata Vantage™ - SQL Data Control Language, B035-1149.
      A list of grantees displays under Grantees.
    2. If User is selected, select the user's 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 Action
      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.
  3. If the selected object type is table or view, then select Column Rights in the left pane to grant or modify column rights.
    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 Teradata Vantage™ - SQL Data Control Language, B035-1149.
      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 Action
      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. Click Commit.
  5. [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.