Granting all view privileges at one time

If the user doesn't have any privileges on a view, and you want to grant the user 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 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 just 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.
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.