Modifying privileges

Use the Properties view to modify privileges on data objects, such as tables and views, or to authorization IDs, such as users, groups, and roles.

Before you begin

You must have the appropriate authority to modify privileges. A connection to the database must also exist. The process to modify privileges is the same as changing any database object:

Procedure

  1. Find the object or authorization ID that you want to modify by using one of the following methods:
    • In the Administration Explorer, expand the database and click the object type folder to display the objects in the Object List. Right-click the object and then click Manage Privileges.
    • In the Data Source Explorer, right-click the object and then click Alter.
    The object is displayed in the Properties view.
  2. Use the Privileges tab to modify the privileges. If you used the Data Source Explorer to find the object, click the Image of Edit icon (Edit) icon on the toolbar in the Properties view. Use the grid and the toolbar buttons to add, modify, or revoke privileges. For database objects, use the check boxes to grant or revoke privileges for one or more of the listed authorization IDs:
    • Image of an empty check box The privilege is off
    • Image of a check box with one check mark The privilege is on without the ability to GRANT the privilege to others
    • Image of a check box with two check marks The privilege is on with the ability to GRANT the privilege to others
  3. Optional: If you are changing the privileges for an object in a DB2® for Linux, UNIX, and Windows database, add any other changes that you want to make the database. You can change multiple objects because a change plan is used for changing DB2 for Linux, UNIX, and Windows databases.
  4. Generate the DDL.
    • For a DB2 for Linux, UNIX, and Windows database: Click the Review and deploy changes icon image (Review and deploy changes) icon in the change plan toolbar in the Object List.
    • For a database that is not a DB2 for Linux, UNIX, or Windows database: Click the Review and deploy changes icon image (Review and deploy changes) icon in the toolbar in the Properties view.
    The Review and Deploy dialog opens.
  5. Click Run, and then click Finish to deploy the changes to the database.
    Remember: If you are not satisfied with the generated DDL, you can open the SQL and XQuery editor to modify the generated DDL. You can change the DDL and then run the DDL script from the editor. You can also use the editor to start the Job Manager, where you can schedule a time to run the script.

Results

The generated DDL script is run on the database. The status of running the commands is displayed in the SQL Results view. You can view the changes by selecting the object in the Object List or Data Source Explorer and viewing the privileges in the Properties view.

Feedback