Granting any view privileges individually

If the user doesn't have any privileges on a view, and you want to grant the user any of those privileges individually:

1. List the view:

   1. Click on Add View. The Add View window opens.

   2. Use the Schema box to specify a schema that includes any views that you want listed. A list of the schema's views appears in the View list box.

   3. Select one or more views.

   4. Click on Apply. The selected view or views are listed in the View column. In addition, Xs appear in the privileges columns and the Privileges boxes specify No. The Xs and Nos mean that the user doesn't have any privileges on the selected view or views.

   5. Optional: Repeat steps b, c, and d to add views from another schema.

   6. Click on Cancel in the Add View window. The window closes.

2. In the View box, select one or more of the views that you had selected in the Add View window.

3. In one or more of the Privileges boxes, select either of these settings:

   Yes

   Grants the privilege 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 VIEW4 and specify Yes in the SELECT box, a check mark framed by corner brackets appears in the SELECT column to the right of VIEW4.

   Grant

   Grants the privilege with the Grant option (not available in the CONTROL box).

   As a sign that the grant is pending, a double 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 VIEW5 and specify Grant in the INSERT box, a double check mark framed by corner brackets appears in the INSERT column to the right of VIEW5.

   The Privileges boxes are:

   • SELECT
   • INSERT
   • UPDATE
   • DELETE
   • CONTROL

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