PIMS User Guides

Manage Groups

In AppFrame databases you can define permissions down to row-level. In addition you also need to specify what kind of access users should have to the data (i.e. read-only or read/update/insert/delete).

The access is defined per group. A user can be a member of one or more groups.

You can manage groups, group members and permissions in the Manage Groups form.

The groups are created and deleted using Data Navigator in the bottom of the form. You can add and remove users from a group in Members tab using the Login lookup in the grid.

Permissions

Row level security

The access is defined for each table. Members of a group could get access to all data in the table (for their current domain), or it could be further restricted based on some criteria fields.

When the database table is designed, up to two criteria fields can be defined. These criteria fields can then be used to restrict the access to the data.

If members of a group will have access to all data in the table, the Criteria value will be “%”.

Types of access

SUID
Select, Update, Insert and Delete. That means that the user will be able to read, modify, delete and add records that satisfy criteria defined in “Row level security”.
SUI
Select, Update and Insert. Same as above, except that the user will not be able to delete any data.
SU
Select and Update.
S
Select – read-only access.

Copy TableRowsPermissions From Other Group

You can use the “->” button, type of access lookup and the grid to set up row level security manually or you can copy table rows permissions from the other Group.

To copy table rows permissions from other group click on the Copy TableRowsPermissions From Other Group button in the taskbar.

Choose the group to copy permissions from in the dialog and click OK.

Clean Up Permissions

Clean Up Permissions sets the basic table rows permissions for the group. The function is located in the taskbar.