Block certain query in Data Virtualization
Hi,
I'm new in Jboss Data Virtualization.
My objective is block (not execute) certain SQL queries to vdb.
I.e. SELECT * FROM TABLE_NAME (is blocked/not execute)
and SELECT * FROM TABLE_NAME WHERE COLUMN_NAME = 'VALUE' (unblock/executable)
Can anyone help me to solve my problem?
Thanks"
Responses
Hello Erfian,
If I understand correctly, you want to enforce users to specify a WHERE clause on COLUMN_NAME column when they want to query the TABLE_NAME table.
To do that, you can use the Access Pattern functionality [1]
[1] https://access.redhat.com/documentation/en/red-hat-jboss-data-virtualization/6.3/paged/development-guide-volume-3-reference-material/147-federated-optimizations
I hope it helps Madou
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.