asked
cannot execute function/stored procedure but can see it
Developer can see a function and store procedure but cannot execute. Any suggestion on how to fix? The developer group they are a member of has the RWX permissions on the database and the two objects. He gets this error: `The EXECUTE permission was denied on the object 'function_name', database 'db_name', schema 'schema_name' ` and `Msg 229, Level 14, State 5, Procedure [stored_procedure_name], Line 1 The EXECUTE permission was denied on the object 'stored_procedure_name', database 'db_name', schema 'schema_name'`
Have you tried explicitly granting execute permissions on the objects? GRANT EXECUTE ON [objectname] TO [Username] Also check to see if any DENY permissions have been assigned. DENY overrules GRANT permissions.
As I mentioned at the end of my answer, make sure you don't have a DENY assigned to the users, as this will override any GRANT you may have assigned. Also make sure you are in the right database when doing all this, you may be connecting to the user's default DB and that may be different to the DB you are aiming for.
