Manage Db2® Privileges panel

You use the Manage Db2® Privileges panel to display, grant, and revoke Db2® privileges.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)               Manage Db2 Privileges

    blank Display privileges                  G Grant privileges
        R Revoke privileges

 Object Identification Criteria:
    Location  . . . . .                       Enter * for list
    Owner . . . . . . .                   +
    Name  . . . . . . .                                                     +
    In  . . . . . . . .                     + Database/table/collection/schema

 Processing Options:
    Object Type
    3   1. Database          7.  Collection         13. Buffer pool
        2. Table space       8.  Schema             14. System
        3. Table             9.  Type               15. Sequence
        4. Column            10. Function
        5. Plan              11. Stored procedure
        6. Package           12. Storage group
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Location
The location of the objects you want listed.
Owner
The name of the person who created the Db2® object.
Name
The name of the Db2® object.
In
An optional field you can use to qualify certain object types.
Object Type
The type of Db2® object against which privilege operations are to be performed. The default is 3 (Tables).

Parent panels

Child panels

To display this panel… Use/do this
Privileges panels Blank command line
Grant privileges panels G on command line
Revoke privileges panels R on command line

Related tasks