By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,286 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,286 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.