Granting all table privileges at one time

To grant all privileges on a table at the same time:

  1. Select the table or tables on which you want to grant privileges.

  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.