Documentations
  • Welcome to PHPRad Documentations
  • Getting Started
    • System Requirements
    • Installation
    • Creating New Project
    • Creating New Database
  • Gallery
    • Component Gallery
  • Connecting to a database
    • Creating Database View
    • Creating Custom View
    • Syncing Database
    • Modifying Database
  • PHPRad Pages
    • Pages
      • Page Fields
      • Page Properties
        • List Page Properties
        • View Page Properties
        • Add Page Properties
        • Edit Page Properties
        • Delete Page Properties
      • Page Field Properties
        • List Page Field Properties
        • View Page Field Properties
        • Add Page Field Properties
        • Edit Page Field Properties
      • Modifying User Page
  • PHPRad Page Design
    • Layout Components
      • Row Components
      • Column Components
    • View Components
      • Accordion
      • Tab Page
        • Tab
      • Form Wizard
        • Step
          • CustomView
      • Modal Component
      • Header Component
      • Custom View Component
    • Page Filter Components
      • Button
      • Search Field
      • Range Field
      • Date Field
      • Multi-Choice List Field
      • Single Choice List Field
      • Select Field
      • Dropdown Menu
      • Nav Filter Menu
    • Menu Component
      • Static Menu
      • Dynamic Menu
    • Record Count Component
    • Chart Component
    • SubPage Component
      • List SubPage
      • View SubPage
      • Add SubPage
      • Edit SubPage
  • Security
    • Authentication
    • Adding Roles and Permissions
    • Adding User Record Management
    • Adding Audit Trail Log
  • Project Theme
    • Applying Project Theme
  • Settings
    • Project Settings
      • Project Configuration
      • Email Configuration
    • Menu Configuration
    • Global Settings
  • Publishing Application
    • Preview Application
    • Publish to Production
  • Project Explorer
    • Editing Project File Manually
    • Editing App Custom Css
Powered by GitBook
On this page
  • Database Table
  • Select table field that match user records
  • Posted By Field
  • Assign To Field
  • Match Record By User
  • Allow Other Users With Roles to Access and Manage Records

Was this helpful?

  1. Security

Adding User Record Management

PreviousAdding Roles and PermissionsNextAdding Audit Trail Log

Last updated 5 years ago

Was this helpful?

Allows user to configure access right on page data for end-users. This means that end-users can only see records they are permitted to see or assigned to.

Database Table

This displays the list of tables available in your Database. To configure, you have to click on the specific table you want end users to have limited access to. In the image below, it would be post database table.

We have three User Roles and Permission; Administrator, User and Staff. So, we will configure who can view, edit and delete a record on the post table.

Select table field that match user records

The below configurations ensures that users only see data/record they added or was assigned to.

Posted By Field

This is the field in the current database table that holds the details of the user who created/added the data to the table.

Assign To Field

This is the field that holds the details of the user who the data or record has been assigned to.

Match Record By User

Allows user to set the field that a user data from Posted By Field or Assign To Field will be validated against n the users Database Table.

If the Posted By Field or Assign To Field holds the id of a user, the Match Record By User should be set to id. this means that, it checks if the end-user currently logged in, and viewing the record matches the user who created it or it was assigned to.

Allow Other Users With Roles to Access and Manage Records

This Allows user to set what actions (List, Edit & Delete) a specific User Role can take on the current page records/data.