Work with Field Security

Navigate to a Field Security by opening the window Field Security by selecting Departments - Compliance - Security - Field and Dataset Security - Field Security.

A Field Security contains the following fields. Configure the Field Security to your preferences.

  • No.: Number of the Field Security, this can be automatic and / or manual, based on the number series settings.
  • Description: A field to describe the Field Security.
  • Table ID: You can select the ID of the table that you want to secure on field level.
  • Table Caption and Module: Automatically filled by the Table ID. You can't modify this.

Note! Blocked tables in the Table Categories cannot be used for field security, If you select a table that is not categorized you will receive a message.

  • Filter Field No.: This field is optionally, you can secure a part of the table by using a filter.
  • Filter Value: This field is optionally, fill in the specific values of the field from the Filter Field No.
  • Module: Automatically filled by the Table ID.
  • Table Type: you can retrieve the available options by entering 0|1|2|3|4|5|6|7|8|9.
  • Data Owner: Select the Data owner, the Data Owner is entitled to manage the field security for the table.
  • Default Editable: Select the option whether all fields of the table, that are not setup in the field security lines, will be editable or non-editable.
  • Start Date: Fill in the date from which the field security applies (required).
  • End Date: Fil in the date until which the field security applies (optional).

Changing the checks in the header applies also modifies the checks in the assigned permission sets.

  • Insert Check: Secure table by insert actions.
  • Modify Check: Secure table by modify actions.
  • Delete Check: Secure table by delete actions.

Complete these fields per line:

  • Field No.: Select the field to be secured.
  • Editable: Select the option. you can choose between editable or non-editable.
  • Initial Field Entry Allowed: Select the option whether the field might be filled and once it is filled it cannot be modified. If this option is not selected, the field security blocks any modification of the field.
  • No. of Assigned Permission Sets: Shows the amount of assigned Permission Sets.
  • Deviating Trigger Checks: Shows if checks differs from checks selected in header.
  • Description: you can use this for documentation purposes.

Note! Some fields are hidden by default:

  • Only Page Control: can disable editability of a field on the page, while it is editable on database level, e.g. from a code unit or a report.
  • Visibility: Fields might be made invisible on a page (customization might be needed).
  • No. of Customized Windows: This shows the number of forms on which the invisibility property for the field is programmed (customized).

After defining the security of a field you have to assign the Permission Set(s) for which the security is applicable. you can assign multiple Permission Sets, use for each Permission Set a new line.

Select the specific line of the secured Field. and click on the arrow down button in the field Permission Set-ID to select the Permission Set for which the security is applicable.

You can optionally set some settings of the assigned Permission Set.

  • Company: Add a company name to set company specific security. If it is empty the security is for all companies.
  • Starting Date: Used for starting the assignment of the Permission Set at a specified date.
  • Ending Date: Used for ending the assignment of the Permission Set at a specified date.
  • 2-controlware/05fieldanddatasetsecurity/2field_security.txt
  • Last modified: 2020/09/28 12:19
  • by marcel