Skip to content

Table Function: Record Access Control

Overview

You can set "Access rights" for "Records" in Table. There is no limit on the number of access permissions that can be granted to a record. "Access Rights" can be granted only to specific records even to "Users" who have not been assigned "Access rights" in "Site Access Control". If "Site Access Control" and "Record Access Control" are set at the same time, both "Access Rights" will be enabled. For example, if "Read Permission" is granted in "Site Access Control" and "Update Permission" is granted in "Record Access Control," both "Read Permission" and "Update Permission" will be enabled.

The "Record access control" tab on the record editor screen, with Permissions on the left and Option list on the right

The number of records retrieved by the "Option list" in a single load is determined by "PageSize" in "Permissions.json".

Limitations

  1. In "Record Access Control", you need to set permissions for each "Record". If you want to narrow down the records displayed in the list screen based on specific conditions, use the "view. Filters object" in "Server Script" or "OnSelectingWhere" in Extended SQL.
  2. You can check "Create Permission" in "Record Access Control", but the create permission is not granted. Please set it in "Site Access Control".
  3. You can check "Export permission" in "Record access control", but the export permission is not granted. Please set it in "Site Access Control".
  4. You can check "Import permission" in "Record access control", but the import permission is not granted. Please set it in "Site Access Control".
  5. You can check "Site Administrator Permission" in "Record Access Control", but the site administrator permission is not granted. Please set it in "Site Access Control".
  6. When "Record Access Control" is configured at the site level, it cannot be configured in the "Record access control" tab of the record editor screen.

Prerequisites

  1. "Read Permission", "Update Permission", and the "Manage permission" permission for "Record" are required.

Operation Procedure

  1. Go to the target table.
  2. Search for the target record from the "List Screen".
  3. Click on the target record.
  4. The "Editor" will be displayed, so open the "Record Access Control" tab.
  5. Select the target "Depts", "Group" or "User" from the Option list and click the "Add Permissions" button.
  6. Click the "Advanced Settings" button, check the required permissions and click the "Change" button.
  7. If there are any unnecessary settings in the "List Of Permission Settings", click them and click the "Delete Permissions" button.
  8. Click the "Update" button.
  9. The process is complete when ""xxxx" has been updated." is displayed. The title of the record will be displayed in place of xxxx.

More Information

  1. You can automatically set "Record Access Control" when creating a "Record". For instructions on how to set it, see "Manage Table: Record Access Control".