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

Reply via email to