mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Security
  • Row Level Security
Back to Manual

Row Level Security for m-Power Applications

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

maintainer_add_sec_values

Create a 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 ‘Application Menu’ screen. Click the Accept 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.

In this brief video I will show you how to apply Row Level security to your applications.

Row level security is a great feature that allows you to specify what records your users can access based on their login credentials. This gives you great control over who can access the records and what records they can access.

Once the security table and the Row Level Security retrieval have been created, you are ready to apply the Row Level security to your application.

As you can see, I have a report listing all the customers; there are over two hundred records listing customers from many different States and regions. I am assigned to work only with customers from the Midwest, which includes these four states: OH, IL, IA, and IN. There is no need for me to see records of customers from other states.

In the security retrieval I had filtered that my user “Zarate” should only be able to access the records where the State is equal to any of these: OH, IL, IA, and IN.

After compiling your application, click Record Selections. From the Field drop down, select the field that you want to control. In my case the field is the Customer state.

From the Selections drop down, select the Row Level Security. From the Values drop down, select the retrieval containing the users and filters for this application. In my case the retrieval 20 contains the filters of what records I can access depending on the user.

Recompile the application without overriding the HTML or Properties. Now, when I run the application I am only allowed to access those records that match my filter on the retrieval.

The above video explains how to integrate the security retrieval we created above with each application you wish to secure.

For users unable to watch the video, you need to go into the application that will be secured. In our case, lets assume it is a Report. Go into Record Selections, and select "Row Level Security" from the "Relation" drop-down. Next, in the value drop-down, you will see a list of all Row Level Security retrievals that have been built in this dictionary. Select the appropriate one and compile. (There is no need to overwrite the HTML).

Editor's Note: When creating the Row Level Security template, please ensure that the 3rd column listed in the column you wish to secure against.

Created: July 8, 2008 | Modified: January 5, 2018

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

mrc-Productivity Series Admin Data Dictionary Tomcat Dates Reports Security Retrieval App Properties Summaries Getting Started Graph Properties Graphs Administration Advanced Video Report External Objects Production Maintainer Java Parameters Build Process Bar Graphs Freemarker m-Painter Email Performance Compiling Prompt Screens DB2 Bootstrap Templates Application Properties Calculations Popular Dropdowns Form Validation SQL Excel Maintainers Record Selections Retrievals RPG Database Graphing

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.