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 commands.
- For a DB2 for Linux, UNIX, and Windows database: Click
the Generate DDL icon. When it generates correctly,
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, and Windows database: Click
the
(Review and deploy changes)
icon in the toolbar in the Properties view.
The Review and Deploy dialog
opens and displays the generated change commands.
- Review the commands in the Review and Deploy dialog
and then specify how to deploy the changes to the database.
Tip: You can modify and then run generated commands in the SQL
and XQuery editor. You can also create a job and schedule
when to run the generated commands in the Job Manager.
Results
The generated commands are 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.