The EXECUTE permission was denied on the object 'zzzzzz, database 'xxxxxx' schema 'yyyyyy',

Question

I'm having problems executing a function...

Here's what I did:

1. create a function using SQL Server Management Studio. It was successfully created.
2. I then tried executing the newly created function and here's what I get:

The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'.

Answer 1

You don't have the right to execute it, although you have enough permissions to create it.

For more information, see GRANT Object Permissions (Transact-SQL)

Answer 2

you need to run something like this

GRANT Execute ON [dbo].fnc_whatEver TO 'domain\user'