Online Documentation for SQL Manager for DB2
Roles
All users interact with a DB2 server within the context of a Role. A user can belong to multiple groups and have multiple roles, and the operations that are permitted by each role determine the actions that a user can perform.
To create a new role:
- select the Database | New Object... main menu item;
- select Role in the Create New Object dialog;
- edit role properties using the appropriate tabs of Role Editor.
Hint: To create a new role, you can also right-click the Roles node of the DB Explorer tree and select the New Role... context menu item.
To edit an existing role:
- select the role for editing in the DB Explorer tree (type the first letters of the role name for quick search);
- right-click the object and select the Edit Role <role_name>... context menu item, or simply double-click the role;
- edit role definition using the appropriate tabs of Role Editor.
To drop a role:
- select the role to drop in the DB Explorer tree;
- right-click the object and select the Drop Role <role_name>... context menu item;
- confirm dropping in the dialog window.
Note: If more convenient, you can also use the following shortcuts:
Ctrl+N to create a new role;
Ctrl+O to edit the selected role;
Shift+Del to drop the object from the database.
