In my opinion, you can do it a couple of ways. You could use the ODBC catalog tool from IBM to restrict them. Or you can set the views to a specific schema name (owner) that has only these views in it. Then set in their DB2 connect system the schema name to this specific schema name. And then they can only see those views.
I'm not sure but I think that to provide access to link to these views, they only need SELECT access to these views of the tables. --- [EMAIL PROTECTED] wrote: > > > 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 > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
