DB2 Help

Use this box to list and select the users to whom you want to grant privileges on the selected view, and users whose privileges on this view you want to revoke. Initially, this box lists the users that already hold privileges on this view. To add other users to the box, click on Add User and select the groups' authorization names on the Add User window.

Next to each user's authorization name, this box displays symbols that indicate whether the user holds privileges on the selected view, and whether grants and revocations of privileges are pending. These symbols change to reflect changes that you make when you use the Privileges boxes or the Grant All or Revoke All push buttons.

The symbols are:

Check marks: An unframed check mark in a column for a privilege means that a user has the privilege without the Grant option. Corner brackets around the check mark indicate that a grant of this privilege, without the Grant option, is pending.
Double check marks: An unframed double check mark in a column for a privilege means that a user has the privilege with the Grant option. Corner brackets around the double check mark indicate that a grant of this privilege, with the Grant option, is pending.
Xs: An unframed X in a column for a privilege means that a user doesn't have the privilege. Corner brackets around the X indicate that a revocation of the privilege is pending.

Add User

Click on this push button to open the Add User window, so that you can supply the User box with authorization names of users that hold no privileges on the selected view.

Grant All

Click on this push button to grant to the selected users or groups whatever privileges they don't hold on the selected view. Grant All also provides the Grant option -- the right to grant a privilege to other users and groups -- on all privileges except CONTROL.

When you click on Grant All:

To the right of the selected users or groups, Xs and single check marks change to double check marks framed by corner brackets. (Exception: An X in the CONTROL column changes to a single check mark framed by corner brackets.) The brackets indicate that the grants that you requested are pending.
The CONTROL box specifies Yes. The other Privileges boxes specify Grant.

Revoke All

Click on this push button to revoke all the privileges that the selected users or groups hold on the selected view.

When you click on Revoke All:

In the columns for the privileges that you're revoking, check marks change to Xs framed by brackets. The brackets indicate that the revocation that you requested is pending.
The boxes for the privileges that you're revoking specify No.

SELECT

This box indicates whether the selected users or groups hold the SELECT privilege, with the Grant option, on the selected view. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes: Grants the SELECT privilege without the Grant option (the right to grant the SELECT privilege on the selected view to other users and groups). If a user or group already has the SELECT privilege with the Grant option, Yes revokes the privilege and re-grants it without the option.
No: Revokes the SELECT privilege.
Grant: Grants the SELECT privilege with the Grant option. If a user or group already has SELECT without the option, Grant provides the option.

The SELECT privilege allows a user to retrieve rows from a view and to create views on a view.

If you select multiple users or groups for whom you specified different settings (for example, Yes for one user andNo for the others), the SELECT box is blank. But the settings that you specified remain in effect.

INSERT

This box indicates whether the selected users or groups hold the INSERT privilege, with the Grant option, on the selected view. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes: Grants the INSERT privilege without the Grant option (the right to grant the INSERT privilege on the selected view to other users and groups). If a user or group already has the INSERT privilege with the Grant option, Yes revokes the privilege and re-grants it without the option.
No: Revokes the INSERT privilege.
Grant: Grants the INSERT privilege with the Grant option. If a user or group already has INSERT without the option, Grant provides the option.

The INSERT privilege allows a user to insert rows into an updatable view.

If you select multiple users or groups for whom you specified different settings (for example, Yes for one user andNo for the others), the INSERT box is blank. But the settings that you specified remain in effect.

UPDATE

This box indicates whether the selected users or groups hold the UPDATE privilege, with the Grant option, on the selected view. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes: Grants the UPDATE privilege without the Grant option (the right to grant the UPDATE privilege on the selected view to other users and groups). If a user or group already has the UPDATE privilege with the Grant option, Yes revokes the privilege and re-grants it without the option.
No: Revokes the UPDATE privilege.
Grant: Grants the UPDATE privilege with the Grant option. If a user or group already has UPDATE without the option, Grant provides the option.

The UPDATE privilege allows a user to update rows in an updatable view.

If you select multiple users or groups for whom you specified different settings (for example, Yes for one user andNo for the others), the UPDATE box is blank. But the settings that you specified remain in effect.

DELETE

This box indicates whether the selected users or groups hold the DELETE privilege, with the Grant option, on the selected view. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes: Grants the DELETE privilege without the Grant option (the right to grant the DELETE privilege on the selected view to other users and groups). If a user or group already has the DELETE privilege with the Grant option, Yes revokes the privilege and re-grants it without the option.
No: Revokes the DELETE privilege.
Grant: Grants the DELETE privilege with the Grant option. If a user or group already has DELETE without the option, Grant provides the option.

The DELETE privilege allows a user to delete rows from an updatable view.

If you select multiple users or groups for whom you specified different settings (for example, Yes for one user andNo for the others), the DELETE box is blank. But the settings that you specified remain in effect.

CONTROL

This box indicates whether the selected users or groups hold the CONTROL privilege on the selected view. To change the box's setting, click on the down arrow and select the setting that you want. You can select:

Yes: Grants the CONTROL privilege.
No: Revokes the CONTROL privilege.

With the CONTROL privilege on a view, a user:

Acquires all other privileges on the view -- SELECT, INSERT, UPDATE, and DELETE
Can grant these other privileges to other users of the view
Can drop the view

If you select multiple users or groups for whom you specified different settings (for example, Yes for one user andNo for the others), the CONTROL box is blank. But the settings that you specified remain in effect.

Group page

Group

Add Group

Grant All

Revoke All

SELECT

INSERT

UPDATE

DELETE

CONTROL

Cancel

Apply

Reset

Show SQL

Group

This box consists of a Group column and a column for each view privilege. The Group column lists user groups by authorization name.

Use this box to list and select the groups to which you want to grant privileges on the selected view, and groups whose privileges on this view you want to revoke. Initially, this box lists the groups that already hold privileges on this view. To add other groups to the box, click on Add Group and select the groups' authorization names on the Add Group window.

Next to each group's authorization name, this box displays symbols that indicate whether the group holds privileges on the selected view, and whether grants and revocations of privileges are pending. These symbols change to reflect changes that you make when you use the Privileges boxes or the Grant All or Revoke All push buttons.