I am trying to create a 'LANGUAGE IS SQL' procedure which dynamically creates an ADS dialog. The dialog is getting created but I'm getting the following error during compilation. Our DBA hasn't figured it out yet so I'm hoping someone lese may have experienced this issue.
The error is:
USER IS NOT AUTHORIZED FOR ACCESS TO THIS DIALOG
Dictionary has option "AUTHORIZATION IS ON FOR ADS" but ADSOCDGN was not provided with the ID of a user in the dictionary for which a "MOD PROGRAM <dialog name> INCLUDE USER <NAME> IS RESPONSIBLE FOR UPDATE" has been done.