Granting all table privileges at one time

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

1. List the table:

   1. Click on Add Table. The Add Table window opens.

   2. Use the Schema box to specify a schema that includes any tables that you want listed. A list of the schema's tables appears in the Table list box.

   3. Select one or more tables.

   4. Click on Apply. The selected table or tables are listed in the Table 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 table or tables.

   5. Optional: Repeat steps b, c, and d to add tables from another schema.

   6. Click on Cancel in the Add Table window. The window closes.

2. In the Table box, select one or more of the tables that you just listed.

3. Click on Grant All. In all privileges columns except CONTROL, the Xs to the right of the selected tables 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 or double check marks unframed.