Hello all,
We have users who want to use Microsoft Access as their adhoc reporting tool
against one of our DB2 databases. I have created views of the tables that I
want to allow them to read-only access, and now I would like to limit their view
of the system catalog to just those views.
So, I have a couple of questions:
1) Does anyone know how to limit an ODBC user connection via Access links to
see only certain tables or views from the system catalog?
2) Does anyone know what the bare bones minimum I have to grant a user is, in
order for that user to be able to link to these views?
Any help would be greatly appreciated!
Judy
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod