Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

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 the lower panel 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:
  • Security (Row-based condition and column masking)
  • Create
  • Read
  • Update
  • Delete
  • Execute
  • Alter
Double-clicking the Security box for a table or column will launch the Model Object Security Definition dialog where you can define applicable values. In order to edit or remove security, select the Conditions or Masking tabs and use the Edit or Remove buttons.
The Conditions and Masks tabs in the Permissions section allow you to manage (add, remove and edit) these values for your model objects.