Granting additional view privileges individually

To grant additional privileges or change Grant options individually:

1. Select the view or views on which you want to grant privileges or change the Grant option.

2. In one or more of the Privileges boxes, select any of these settings:

   Yes

   If the box initially said No, then Yes grants the privilege without the Grant option (the right to grant this privilege to others). If the box initially said Grant, then Yes revokes the privilege and re-grants it without the Grant option.

   As a sign that the grant is pending, a check mark framed by corner brackets appears in the column for this privilege to the right of each selected view. For example, if you select VIEW1 and specify Yes in the UPDATE box, a check mark framed by corner brackets appears in the UPDATE column to the right of VIEW1.

   Grant

   If the box initially said No, then Grant grants the privilege with the Grant option (not available in the CONTROL box). If the box initially said Yes, then Grant retains the privilege and adds the Grant option.

   As a sign that the grant is pending, a double check mark framed by corner brackets appears in the appropriate privilege column to the right of each selected view. For example, if you select VIEW2 and specify Grant in the DELETE box, a double check mark framed by corner brackets appears in the DELETE column to the right of VIEW2.

   The Privileges boxes are:

   • SELECT

   • INSERT

   • UPDATE

   • DELETE

   • CONTROL

3. Click on Apply. As a sign that the privileges have been granted, the corner brackets disappear, leaving the single and double check marks unframed.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]