Investigate Crud Operation and Field Permission

Use this page to investigate whether a user has restrictions on CRUD operations or on specific Fields.

The page has two tabs: CRUD Operations and Field Permissions.

Crud Operations

In the CRUD Operations Permissions, the following fields are available:

Field's Description

  • User Name

    The name of the user. If User Type is Group, this field is not displayed.

  • User ID System-generated integer to uniquely identify a user instance in the system. Read-only.

  • Menu The menu where the Entity Table Name may be accessed.

  • Entity Table Name The name of the table to which the operations are limited.

  • Allow Read When checked, the user/group may read records from the Entity Table(s).

  • Allow Create When checked, the user/group may create records from the Entity Table(s).

  • Allow Update When checked, the user/group may update records from the Entity Table(s).

  • Allow Delete When checked, the user/group may delete records from the Entity Table(s).

  • Comments

    Explains the limitations of the permissions.

    • If CRUD restrictions are defined at the menu level only, then allow/deny is limited to respective menu/page and all entity tables within that page.      
    • If CRUD restrictions are defined at the entity table level only, then allow/deny is limited to the entity table and all menus/pages where it may be used.
    • If CRUD restrictions are defined at the menu and entity table, then allow/deny is limited to the respective menu/page and entity table only.       

    The CRUD Operation restrictions are defined using the Application Permissions menu.

Field Permissions

The field permissions are defined using the Application Permissions menu.

In the Field Permissions, the following fields are available:

Field's Description

  • User Name

    The name of the user. If User Type is Group, this field is not displayed.

  • User ID System-generated integer to uniquely identify a user instance in the system. Read-only.

  • Menu The menu where the Entity Table Name may be accessed.

  • Entity Table Name The name of the table to which the fields are limited.

  • Field Name(s) The specific fields where there are explicit restrictions

  • Entity View Name The name of a view to which the fields are limited.

  • Hidden Create When checked, the field(s) are not visible during a Create operation.

  • Hidden Edit When checked, the field(s) are not visible during an Edit operation.

  • Hidden Read When checked, the field(s) are not visible during a Read operation.

  • Disable Create When checked, the field(s) are read-only during a Create operation.

  • Disable Edit When checked, the field(s) are read-only during a Create operation.

Permission Filter

In the Permission Filter, the following fields are available:

Click the Apply Filter button when done.

Field's Description

  • User Name Displays the list of all users or groups – depending on the User Type selected – from the Active Directory. If left blank, all users or groups will be analyzed.

  • User Type Select either User or Group