Managing Db2® privileges
Use the Privileges utility function to display, grant, and revoke Db2® privileges.
To perform these functions, you use the Manage Db2® Privileges panel.
The available functions for managing Db2® privileges
are shown in Privilege functions.
| Privilege Type | Grant | Revoke |
|---|---|---|
| Database | Yes | Yes |
| Table space | Yes | Yes |
| Table/View | Yes | Yes |
| Column | Yes | No1 |
| Plan | Yes | Yes |
| Package | Yes | Yes |
| Collection | Yes | Yes |
| Schema | Yes | Yes |
| Distinct type | Yes | Yes |
| Function | Yes | Yes |
| Stored procedure | Yes | Yes |
To display the Manage Db2® Privileges panel,
- From the Primary Option Menu panel, enter
3(Utilities) to display the Utility Functions panel. - From the Utility Functions panel, enter
5(Privileges)
Related tasks
Related references
1 You cannot revoke privileges on specific columns. You must revoke the appropriate table
privileges.