Granting all table privileges at one time

To grant all privileges on a table at the same time, and to provide the Grant option with all privileges except CONTROL:

  1. Select the table or tables that you want to grant privileges on.
  2. Click on Grant all. The Xs across from the selected tables are replaced by new symbols. In the Control column, these symbols are check marks framed by corner brackets. In the other privileges columns, the symbols are double check marks framed by corner brackets.

    The framed check marks mean that your grant of the CONTROL privilege is pending. The framed double check marks mean that your grant of the other table privileges, with the Grant option, is also pending.

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