467,134 Members | 983 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Bind Error while using ALIAS on VIEW with other owner (DB2 OS/390)

We have following situation:

USER1 uses secondary-IDs SEC1 and SEC2

We defined an ALIAS with

SEC1.ALIAS1 => SEC2.VIEW1 => SEC2.TABLE1

and GRANT SELECT user SEC1 on VIEW SEC2.VIEW1.

We also defined a VIEW with

SEC1.VIEW2 => SEC1.TABLE1

in a COBOL we joined the ALIAS with the VIEW

SEC1.ALIAS1 <-> SEC1.VIEW2

an bound the programm with

OWNER(SEC1) QUALIFIER(SEC1)

The BIND abended with SQL-code -551 which said user SEC1 doesnot have
SELECT authority on VIEW SEC2.VIEW1.

We found that it is no problem to run the JOIN within SPUFI. Got
anyone an idea what is the problem with the BIND?
Nov 12 '05 #1
  • viewed: 1972
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Strategic Mind | last post: by
5 posts views Thread by Santiago Ordax Solivellas | last post: by
4 posts views Thread by banz@glion.ch | last post: by
reply views Thread by anaik100 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.