22 May 2012
The forum seach is horrible but google search find these as welll ;-)
http://forums.teradata.com/forum/database/problems-with-two-views-on-different-databases
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
22 May 2012
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?
-Sen
25 May 2012
Rpad_2 is a reference to a UDF.
25 May 2012
Thanks ToddAWalter!
You must sign in to leave a comment.
Hi All,
i have created a view, when i query the view im getting below error.
SELECT Failed [3523] 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.
-Sen