As the DBADM or SYSADM create an alias of the source table with schema JACK. Like: db2 create alias JACK.TABLE1 on TOM.TABLE1 HTH, Pierre. Pierre Saint-Jacques IBM Certified Solutions Expert - Administration SES Consultants Inc. [EMAIL PROTECTED] ----- Original Message ----- From: "r x" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 1:01 AM 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
