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
──────────────────────────────────────────────────────────────────────────────
ZDT/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 | Gon command line |
Revoke privileges panels | Ron command line |