David,
It is possible to limit what individual users can access through ODBC.
You do this by enabling Security from within the Pervasive Control Center.
When you enable security, you assign a password to the 'Master' user.
The Master user has access to all tables.
DO NOT FORGET THIS PASSWORD! From that point, you can Add a user and click checkboxes next to the 'select' operation for
tables that you want them to access.
I set up a generic user called 'dba' with checkboxes next to only the tables that my
CR reports need access to.
When CR refreshes a report, it will prompt for a username and password.
Here's the problem:
If you use JDBC access from EVO, you cannot secure your DDF files That's why I submited
THIS enhacement request on Mantis.