Privelege issue

Database
N/A

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

4 REPLIES
N/A

Re: Privelege issue

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

N/A

Re: Privelege issue

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

Teradata Employee

Re: Privelege issue

Rpad_2 is a reference to a UDF.
N/A

Re: Privelege issue

Thanks ToddAWalter!