Generating and running GRANT DCL statements

Before you begin

You must have the required Db2 privileges.

To generate and run a GRANT DCL statement

1. In the DB2 Navigator perspective, select one or more of the supported objects.
   For more information, see Navigating to an object.

2. On the Tasks toolbar, click Grant .

   Success

   Tip

   You can also right-click a selected object and select Grant from the menu.

   The Grant <object> Privileges dialog box is displayed.

3. On the Auth Names tab, use the following buttons to add users and roles:

   • Add Authorization Id
   • Add Role

4. On the Privileges tab, select one or more object privileges that you want to grant to the added users and roles.
   Only the object privileges related to the selected object are displayed.

5. (Optional) To include the WITH GRANT OPTION clause, select With Grant.

6. On the Object List tab, you can review the objects to which you are granting the users and roles privileges.

7. Click Generate DCL.
   The Grant DCL statement is displayed in the Scratchpad perspective.

8. Click Run  to run the Grant DCL statement.

9. (Optional) To save the Grant DCL statement, perform the following steps:

   1.  Click Save .

   2. In the File name field, enter an existing data set name.

   3. Click OK.