To grant all additional view privileges in one
operation:
- Select the view or views that you want to grant the privileges on.
- Click on Grant all. The Select Grant Option window
opens. In all privileges columns except CONTROL, any Xs and
check marks 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, any 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.
- Click on Apply. As a sign that the privileges have been
granted, the corner brackets disappear, leaving the single or double check
marks unframed.