Hi, I guess Public still has select rights on those tables. You would have to revoke those rights in order for your users not to see them.
Thanks, Mark > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: 15 January 2002 19:51 > To: [EMAIL PROTECTED] > Subject: [DB2EUG] Limit users' access to the DB2 catalog > > > > Hello all, > > I have created views on some tables in one of our production databases. > Next I > created an aix id and to that id, I granted select only privileges to > those > views I created. The purpose of this id and these views is to allow some > of our > users read-only access to this data via Microsoft Access. They will open > an > Access database, then use the DB2 ODBC driver to link to the DB2 tables > from > there. The only id they will be able to do this with is the id I set up > and > granted select only privileges to. > > Now, here is my question: when they go to choose the tables they want to > link > to, they can see ALL of the tables in the DB2 catalog table, > SYSCAT.TABLES. Is > there a way that I can limit what they can see to only those views I > created for > them? > > Many thanks, > Judy > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
