Granting Permissions for Tables

Permissions for specific tables can be granted to a specific user, or group.

DBEdit must be open and an ODBC Data Source connection must be made.
  1. Open a *.dbd or *.db-schema file.
  2. Connect to an ODBC Data Source.
  3. Click Tables.
    A list of tables in the *.dbd or *.db-schema file appears in the right pane.
    List of data tables
  4. Right-click on the table for which you want to define permissions and click Grant Permissions.
    The Select Permissions dialog appears.
  5. Select the check box of the actions you want to allow.
    • Select
    • Insert
    • Update
    • Delete
    • References
      • For Oracle database users - If selected, users can create a foreign key dependency on a table or materialized view. The References permission on a parent table implicitly grants Select privilege on the parent table.
      • For SQL database users - If selected, users can create a foreign key constraint that references that table.
    • Execute
  6. In the User/Group/Role field, select the data source user, role, or group to be granted permission.
  7. Click OK.