Row Level Security for m-Power Applications
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 a security table and populate it with data. It may contain several records per user.
Note: 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
Create a retrieval over this security table.
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.