Hi,

I have encountered a strange security problem recently, I send sql server
functions to my clients and when they install them, it seems execute
permissions are turned off by default (at least this happened to 2 of my
clients: they encountered lack no execute permissions on those functions).
Are there any differences in the default security settings for triggers and
functions, because I never encountered this with triggers.
Does this mean that it is a standard procedure after you install functions
through query analyzer like
Create function dbo.function_name
AS....

A DBA has to go to Management Studio and set Execution permission for
certain users, otherwise by default they would have deny Execution?

Thank you,

Vadim