Granting any table privileges individually

If the user doesn't have any privileges on a table, and you want to grant the user any of those privileges individually:

  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 had selected in the Add Table window.

  3. In one or more of the Privileges boxes, select either of these settings:

    Yes
    Grants the privilege without the Grant option.

    As a sign that the grant is pending, a check mark framed by corner brackets appears in the column for this privilege to the right of each selected table. For example, if you select TABLE4 and specify Yes in the ALTER box, a check mark framed by corner brackets appears in the ALTER column to the right of TABLE4.

    Grant
    Grants the privilege with the Grant option (not available in the CONTROL box).

    As a sign that the grant is pending, a double check mark framed by corner brackets appears in the column for this privilege to the right of each selected table. For example, if you select TABLE5 and specify Grant in the INDEX box, a double check mark framed by corner brackets appears in the INDEX column to the right of TABLE5.

    The Privileges boxes are:

  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.