Row level security (RLS) ensures that reviewers (or any search user) cannot see events associated with users outside of their management groups when searching the CMS database for events. RLS can also be applied based on certain policies that the reviewer can see.
By making changes to views, the policy RLS search has been improved and displays results faster. The primary change is the denormalization of frequently searched criteria to the Wgn3EventParticipant, QueryFlags and Wgn3Trigger. QueryFlags column reduces the number of table joins and allows highly selective indexes containing reviewed or unreviewed events to be generated.
Important! The RLS search performance enhancement applies to RLS models only. This optimization does not apply to Administrator or Unrestricted RLS models.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|