Online Documentation for SQL Manager for DB2

Managing grants


The Grants tab of Role Editor allows you to manage grants for the role.

 

Role Editor - Managing grants

 

 

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

 

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

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

 

For details see Grant Manager.