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.