Revoking Permissions for Tables

Permissions for specific tables can be revoked (that is, denied) for 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 Revoke Permissions.
    The Select Permissions dialog appears.
  5. Clear the check box of the actions you want to revoke.
    • Select
    • Insert
    • Update
    • Delete
    • References
    • Execute
  6. In the User/Group/Role field, select the data source user, role, or group to be denied permission.
  7. Click OK.