User/App/Table permissions

User/App permissions on all tables

Permissions can be defined on all tables for a given user/app with the Permissions button in the toolbar:



To set the INSERT, UPDATE and DELETE permissions for users in the DB Sync user console:

  1. Select a user in the list.

  2. Click Permissions in the toolbar.

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


The permissions are applied on all tables for the current user and the selected app.

Specific User/App/Table permissions

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



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

  1. Select a user in the user list.

  2. Choose an application in the Application combobox.

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

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