Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to create Tables common for multiple user id's

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kumaresh.M

New User


Joined: 17 Feb 2006
Posts: 64
Location: Bangalore

PostPosted: Mon Feb 05, 2007 12:31 pm    Post subject: How to create Tables common for multiple user id's
Reply with quote

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
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon Feb 05, 2007 1:47 pm    Post subject:
Reply with quote

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
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Mon Feb 05, 2007 2:45 pm    Post subject: Re: How to create Tables common for multiple user id's
Reply with quote

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
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Tue Feb 06, 2007 9:52 am    Post subject: Re: How to create Tables common for multiple user id's
Reply with quote

Hi,

Instead of Synonym use Alias that may work fine
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Thu Feb 08, 2007 6:09 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us