Online Documentation for SQL Manager for DB2

Managing grants


The Grants tab of User Editor allows you to manage grants for the user.

 

User Editor - Managing grants

 

 

The column(s) following the Object Name column indicate(s) the permission(s) that can be granted to the user on the selected database object: table space, schema, table, materialized query table, Index, view, package, function, procedure, nickname, SQL variable, security label, module.

 

Right-click a cell to grant a permission to the user. The context menu of a cell allows you to:

  • grant a permission to the user;
  • grant a permission (with Grant Option) to the user;
  • revoke a previously granted permission.

 

For details see Grant Manager.