Granting all table privileges at one time

If the group doesn't have any privileges on a table, and you want to grant the group 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 tables that you want to grant privileges on. A list of the schema's tables appears in the Table list box.
    3. Select the table or tables that you want.
    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 group doesn't have any privileges on the selected table or tables.
    5. Optional: Repeat steps b, c, and d to add tables in 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 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.

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

  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.


Related information