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

Question

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

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

Sounds like you need to grant the execute permission to the user (or a group that they a part of) for the stored procedure in question.

For example, you could grant access thus:

USE zzzzzzz;
GRANT EXEC ON dbo.xxxxxxx TO PUBLIC