All Forums Database
Sen_td 20 posts Joined 08/11
22 May 2012
Privelege issue

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

ulrich 816 posts Joined 09/09
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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Sen_td 20 posts Joined 08/11
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

ToddAWalter 316 posts Joined 10/11
25 May 2012

Rpad_2 is a reference to a UDF.

Sen_td 20 posts Joined 08/11
25 May 2012

Thanks ToddAWalter!

You must sign in to leave a comment.