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
- 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.
- Use the Privileges tab
to modify the privileges. If you used the Data Source Explorer to
find the object, click the
(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:
The privilege is off
The privilege is
on without the ability to GRANT the privilege to others
The privilege is
on with the ability to GRANT the privilege to others
- 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.
- Generate the DDL.
- For a DB2 for Linux, UNIX, and Windows database: Click
the
(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 in the toolbar in the Properties view.
The Review and Deploy dialog
opens.
- 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.