Granting all view privileges at one time

If the group doesn't have any privileges on a view, and you want to grant the group all privileges on the view at the same time:

  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 views that you want to grant privileges on. A list of the schema's views appears in the View list box.

    3. Select the view or views that you want.

    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 group doesn't have any privileges on the selected view or views.

    5. Optional: Repeat steps b, c, and d to add views in 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 listed.

  3. Click on Grant all. In all privileges columns except CONTROL, the Xs to the right of the selected views are replaced by double check marks framed by corner brackets. These new symbols indicate that grants of privileges, each with the Grant option, are pending. In the CONTROL column, Xs are replaced by single check marks framed by corner brackets. These new symbols indicate that grants of CONTROL are pending.

    In addition, the CONTROL box specifies Yes and the other Privileges boxes specify Grant.

  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.


Related information