Problem during bind with permission

rajandhla · Posted: Wed Feb 06, 2008 11:05 am

Hi Experts,

i have created few tables with owner xyz (i.e create xyz.table1...)
and i have granted permission to other owner ABC.

I am using those tables in the cobol program and doing bind using the owner ABC. But it is not allowing me to do bind saying object not found.

Bind permission for the plan also granted on the new owner.

Here i suppose to use owner ABC during bind.

please let me know any thing am i missing.

Many Thanks,
JR

vebs · New User Joined: 27 Oct 2007 Posts: 19 Location: UK

I cant say if anything is wrong in your method, but as an extended check, you can query SYSIBM.SYSTABAUTH, SYSIBM.SYSPLANAUTH etc table to find if your GRANT was successfull or not. If it was successful, then problem lies elsewhere and not with GRANT..............

Anything else you can provide us with.....

rajandhla · Posted: Thu Feb 07, 2008 10:01 am

By doing aliasing the tables will it work.

xyz.table1 to abc.table1

Thanks,
JR