On 11/05/2010 08:58 PM, Zhixuan Zhu wrote:
> Now my question is how to limit a regular user's privilege to execute
> the UDF functions. We don't want all users to have access to those
> functions. But it looks like a new created user without any privilege
> granted can execute "select xxxx()". Is there anyway to work around
> this?
only from within the function i'm afraid ... so it would be the
responsibility of the UDF itself to check the user information
from the security context of the current thread against its own
internal permission information ...
--
hartmut
