App/Table permissions

App permissions on all tables

Permissions on all tables used by the current app can be easily set with the Permissions button in the toolbar:



INSERT, UPDATE and DELETE permissions can be specified for all SQL tables used by the current selected application:

  1. Select the application and click Permissions in the toolbar.

  2. Click Yes or No to the following permission prompts:
    • Can users append rows in all tables of 'app_library'?
    • Can users modify rows in all tables of 'app_library'?
    • Can users remove rows in all tables of 'app_library'?

The permissions are applied to the application.

Specific App/Table permissions

INSERT, UPDATE and DELETE permissions can be specified at the table level for a given app, for all users:



To change the permissions on a table for a given app:

  1. Select an appliction in the app list.

  2. Select Allowed or Denied option in the comboboxes of Insert, Update and Delete columns, for each table associated to the current app.

  3. Changes are automatically saved when changing the permission option.