Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us