i have created a view, when i query the view im getting below error.
SELECT Failed  An owner referenced by user does not have EXECUTE FUNCTION WITH GRANT OPTION access to SYSLIB.rpad_2.
But i can execute the SELECT part of the view successfully. Looks like privelege issue but not sure what is the issue. Can anyone help me figre out the root cause for this.
The forum seach is horrible but google search find these as welll ;-)
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
Thanks Ulrich for the response! i got this issue before usually it show me database and object name but this time shows me "SYSLIB.rpad_2". Any idea what does this mean?
Rpad_2 is a reference to a UDF.