Ravi,
The problem with the "alias" solution that some have suggested is that
"Jack" can check syscat.tables to find out the name and schema of the base
table.
A different approach not requiring an alias would be to put the original
table in a schema that is not tied to a particular user's name. "Jack"
could select from that without knowing who is the business owner of the
data. The effectiveness of this approach depends on how the table is
updated. It would work especially well if updates to the table are made by
an application program and not by individual users using SQL, since the
identities of the latter would be revealed in syscat.tabauth.
Steve Westfall
Equifax, Inc.
|---------+--------------------------->
| | r x |
| | <dbadb2udb@yahoo|
| | .com> |
| | Sent by: |
| | owner-db2eug@Lug|
| | wash.org |
| | |
| | |
| | 01/09/2003 12:01|
| | AM |
| | Please respond |
| | to r x |
| | |
|---------+--------------------------->
>---------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| 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
