Row Level Security

Click here to access the legacy version of this documentation.

Row Level Security is a highly flexible technique for controlling which records are returned based on the current user. The following few steps demonstrate the technique.

Create Table

Create a security table and populate it with data. It may contain several records per user.

You must enter the username in ALL UPPERCASE. Doing this will allow for the end user to be non-case specific at run-time.

This example has fields Profile (10A), Relationship (2A), and Values (99A). Valid values for the Relationship field include:

  • EQ Equal to
  • GE Greater than or equal to
  • GT Greater than
  • LE Less than or equal to
  • LS Is in the list
  • LT Less than
  • NE Not equal to
  • NG Not greater than
  • NL Not less than
  • RG Is in the range
  • SW Starts with
maintainer_add_sec_values

Create Security Retrieval

Create a row level security retrieval over this security table.

Security advanced record.bmp

Here is the listing of all the fields used in the retrieval application. Sequence your application by the field containing user profile (USERNAME in this case). Please do not name the user field USER. That is a reserved Java field.

Select the Row Level Security template in the ‘Application Settings’ link from the ‘Edit Application Template’ screen. Click the Save button to save your changes and compile your application. This specific template tells m-Power that this application contains security credential information. Further, by selecting this template, you allow future applications to apply this security via the Record  Selections Screen.

Video Tutorial

Updated on September 28, 2021

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support