Pinned topic UDF EXECUTEAUTH
nivanov1 100000H9H7231 Posts
Re: UDF EXECUTEAUTH2013-12-31T17:26:25ZThis is the accepted answer. This is the accepted answer.
There is no problem. This is documented behaviour.
The definer of a function always receives the EXECUTE privilege on the function, as well as the right to drop the function. The definer of a function is also given the WITH GRANT OPTION on the function if the definer has WITH GRANT OPTION on all privileges required to define the function, or if the definer has SYSADM or DBADM authority.
iamnovice 270002F5085 Posts
Re: UDF EXECUTEAUTH2014-01-02T14:07:09ZThis is the accepted answer. This is the accepted answer.
hi nivanov1, thanks for your reply.
I have another UDF, the EXECUTEAUTH of which is G. I compared each column in syscat.routines for those two UDF, but can't tell the difference between them.