Online Documentation for SQL Manager for DB2

Managing grants


The Grants tab of Group Editor allows you to manage grants for the group.

 

Group Editor - Managing grants

 

 

The column(s) following the Object Name column indicate(s) the permission(s) that can be granted to the group 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 group. The context menu of a cell allows you to:

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

 

For details see Grant Manager.