Add Data Security (VPM)

This feature is available only in Enterprise Edition.

A Virtual Private Model (VPM) is an optional component that provides a highly flexible and comprehensive security layer for relational data sources. The VPM controls security for individual database tables and physical views, filtering all queries that reference these tables or models. The VPM is invisible to users, transparently providing access only to data for which a given user is authorized.

A VPM consists of conditions, hidden columns, lookups, and their associated triggers. Conditions and hidden columns allow you to filter rows and columns, respectively. Triggers provide fine-grained control on conditions and hidden columns by role, group, and individual user. Multiple VPMs can be specified for a given data source, and these are joined in an ‘and’ fashion.

The following sections explain how to create and edit a VPM.

Create a New VPM
Create a Condition
Create a Hidden Column
Add a Condition Trigger
Add a Hidden Column Trigger
Add a Lookup Trigger
Test a VPM
Filter Unparsable Queries