14.7. Security and Data Access

You have some options on defining your data access security for your VDB via the VDB Editor.

The first level is provided by the model visibility check-box in the Models section (Spyglass column). If unchecked, that model and its contents will not be returned by the Teiid runtime with the standard JDBC metadata.

The next level of security is provided defining permissions for your data roles which can be managed via Data Roles tab in the VDB Editor. For a unique data role, each model and most objects within that model can have specific values of data access including the following:

Double-clicking the Security box for a table will launch the Row Filter Definition dialog where you can define condition. Double-clicking the Security box for a column will launch the Column Masking Definition dialog where you can define condition and column masking. In order to edit or remove security, select the Row Filter or Column Masking tabs and use the Edit or Remove buttons.