Topic
  • 2 replies
  • Latest Post - ‏2014-01-02T14:07:09Z by iamnovice
iamnovice
iamnovice
5 Posts

Pinned topic UDF EXECUTEAUTH

‏2013-12-31T06:58:06Z |
Hi
I created an user defined function, but then EXECUTEAUTH of owner in SYSCAT.ROUTINEAUTH is not 'G' but 'Y'
where is the problem?
Thanks.
  • nivanov1
    nivanov1
    231 Posts

    Re: UDF EXECUTEAUTH

    ‏2013-12-31T17:26:25Z  

    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
    iamnovice
    5 Posts

    Re: UDF EXECUTEAUTH

    ‏2014-01-02T14:07:09Z  

    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.