Ravi, Look at the CREATE ALIAS command. Something like:
CREATE ALIAS JACK.A FOR TOM.A but check the syntax, as I'm working from memory. Regards, Greg -----Original Message----- From: r x [mailto:[EMAIL PROTECTED]] Sent: Thursday, 9 January 2003 2:02 PM To: [EMAIL PROTECTED] Subject: [DB2EUG] Table Access without specifying schema name Hi List, DB2 V7.2 on AIX Table A is owned by user Tom. User Jack also needs to access the table ( say for select only ). But i do not want Jack to know who the table owner is i.e i do not want jack to specify schema.tablename in the query ( like select * from Tom.A ) . Jack should be able to select using the tablename only ( without schemaname, select * from A ). Any ideas please. Thanks, Ravi. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
