View previous topic :: View next topic
|
Author |
Message |
avelayudhan
New User
Joined: 30 Nov 2005 Posts: 26
|
|
|
|
Hi,
I am developing a program and using a table which is created by me. The program uses many other tables which have a different owner. When binding the plan for this program, how do we specify different owners for tables?
A simple bind card looks something like this. Here the owner DEVLPTC is the owner of most of the tables in the program PTCB99. One table has th owner TS2379. How do we specify this in the bind card? Any suggestion is greatly welcomed!
DSN SYSTEM(DSNY)
BIND PLAN(PTCB99) OWNER(DEVLPTC)
MEMBER(PTCB99)
ACT(REP)
ISO(CS)
VALIDATE(BIND)
ACQUIRE(USE)
EXPLAIN(NO)
END |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy avelayudhan,
the owner of a plan can be different from the owner of the included
tables. therefore you won't be able to change the owner in the bind step
while binding. it is more important, that the user, which will use this program, has the appropriate rights to access, the tables.
martin9 |
|
Back to top |
|
|
avelayudhan
New User
Joined: 30 Nov 2005 Posts: 26
|
|
|
|
Hi Maritn,
You from Switzerland!! I am planning a trip to Switzerland this summer for 10 days. Maybe you could be a guide to us!!
Hey, my bind is failing since that time has owner TS2379 which is not what is in OWNER parameter of the bind jcl. So, the question is how could we circumvent this issue of bind? any idea?
Thanks |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy,
owner DEVLPTC must have the right to include
tables form owner TS2379.
what did you get sql -511 ???
martin9 |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy guys,
if you come to Switzerland,
send me a email before leaving,
maybe we can arrange something...
martin9 |
|
Back to top |
|
|
avelayudhan
New User
Joined: 30 Nov 2005 Posts: 26
|
|
|
|
Yes, I am getting -511 during bind..by the by, what is your email..? |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy avelayudhan,
as i thought, you have a problem with the rights,
make a correct GRANT that the first owner has
access for the other. contact your dba, he will do it.
my email is:
martin.holm@helvetiapatria.ch
martin9 |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi avelayudhan,
Create a alias under DEVLPTC which is pointing to table under TS2379 and then give neccessary access on the table(select,update,delete) to DEVLPTC .
Then use the same bind card while binding.
It should go thru.
Hope you understand what I said.
Thanks
Rags |
|
Back to top |
|
|
|