Define reading and writing rights for a database table

In this topic, you learn how to assign the right to read and edit database tables to certain roles.

Role Read

Users with the role Read can retrieve the data from the database table but not edit it.

Role Write

Users with the role Write can both retrieve and edit data from the database table.

Prerequisites

Procedure

  1. In the Cockpit, go to Tools and select Table Definition.

  2. Select the database table for which you want to define reading and/or writing rights.

    Result: The Table Definition configuration window opens.

  3. Go to one of two tabs:

    1. If you want to add a role with reading rights, go to the Role Read tab.

    2. If you want to add a role with writing rights, go to the Role Write tab.

  4. If you are in display mode, select Edit.

  5. Select + Add on the table toolbar.

    Result: The Role dialog opens.

  6. Select one or more roles that you want to give reading or writing rights to.

  7. Select Select.

    Result: The roles you selected are added to the table.

  8. Select Save.

Results

  • You have defined reading or writing rights for a database table.