4.6.3 VPM Hidden Columns

You can specify columns of a table to which VPM access control should be applied. To add access control to table columns, follow these steps:

1. Open the Asset panel, and expand the 'Data Source' node.

2. Expand the data source that contains the VPM you want to edit. Double-click the VPM to open it for editing.

3. In the VPM edit view, click the Hidden Columns tab at the bottom of the window.

4. Drag the desired columns from the 'Available Columns' pane to the 'Hidden Columns' pane.

The columns listed in the 'Hidden Columns' pane are automatically hidden from all users, except for those who are associated with at least one of the roles listed in the 'Grant to' pane.

5. Add the desired roles to the 'Grant to' pane by clicking the arrow button.

 

6. Click 'Save' in the Style Studio toolbar to save the changes to the VPM.

Once the hidden columns are specified, the tables containing those columns are automatically listed in the Lookup tab. This indicates that the VPM security will be applied to any query that contains those tables.

A column that is derived from one or more hidden columns by an expression will be accessible only to users who have permissions for all of the columns used in the expression. However, for unparsable queries, derived columns should be explicitly tagged; see VPM Filtering of Unparsable Queries.

<< 4.6.2 VPM Conditions © 1996-2013 InetSoft Technology Corporation (v11.5) 4.6.4 Trigger Scripts >>