View previous topic :: View next topic
|
Author |
Message |
kumaresh.M
New User
Joined: 17 Feb 2006 Posts: 64 Location: Bangalore
|
|
|
|
Hi,
In my team 22 members is there,we have to create some common tables to access by all userids without using the highlevel qualifiers
I created all the necessary db2 objects like synonyms and indexes in one userid and granted all access to public.
but iam not able to access the tables from other userids.
anybody gives some suggestions to slove this Problem ?
With regards,
kumaresh.m |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Quote: |
iam not able to access the tables from other userids |
What sort of code or reason do you get when you try?
And what do you mean by "from other userids"? |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
First of all i wonder how you were able to GRANT the privileges on the SYNONYM you created to the other users. Those are private things. if it is created by your user id, its you and only you who can access it. The basic concept in DB2 is any object reffered to should have an HLQ. if it is not there then by default you CURRENT SQLID will be considered as the object owner.
I haven't come across such instances. but your requirement seems to be quite strange. As of now what i have in my mind is to define the common synonym name on a table for all the userid's. i.e ask each one of them to define the synonym on the table, and give the same name. Still it will be like they are not using the same object (SYNONYM) but the base object (table) being referred would be same. This is not advisable too. And I'm sure no where, no one would recomend this..!! |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi,
Instead of Synonym use Alias that may work fine |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
Still he needs to give the HLQ for an ALIAS. I agree he can define an alias on the base table and GRANT the necessary privileges to all the required users. Alias wont work if dont want to use the High level qualifier. that comes to two part name. |
|
Back to top |
|
|
|