Listing tables

To list the table or tables that you want to grant privileges on:

  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. In the Table list box, select the table or tables that you want to grant privileges on.
  4. Click on Apply. The selected table or tables are listed in the Table column. In addition, Xs appear in the privileges columns and No appears in the Privileges boxes. The Xs and Nos mean that the user doesn't have any privileges on the selected table or tables.
  5. Optional: Repeat steps 2, 3, and 4 to add tables from another schema.
  6. Click on Cancel in the Add Table window. The window closes.