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
More Related Contents:
- incorrect syntax near keyword where [closed]
- nvarchar concatenation / index / nvarchar(max) inexplicable behavior
- How do I create a unique constraint that also allows nulls?
- How do I get list of all tables in a database using TSQL?
- How to convert SQL Server’s timestamp column to datetime format
- Multiple rows to one comma-separated value in Sql Server [duplicate]
- Escape a string in SQL Server so that it is safe to use in LIKE expression
- SQL Server: Difference between PARTITION BY and GROUP BY
- How do you truncate all tables in a database using TSQL?
- Import ‘xml’ into Sql Server
- Query times out when executed from web, but super-fast when executed from SSMS
- Efficient ISNUMERIC() replacements on SQL Server?
- Login to Microsoft SQL Server Error: 18456
- SQL Server datetime LIKE select?
- Adding a query hint when calling Table-Valued Function
- Find non-ASCII characters in varchar columns using SQL Server
- Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
- How can I determine in SQL Server if a dateTime range overlaps another
- Intermittent ODBC connection failures
- SQL Server Query – groupwise multiplication
- SQL Server recursive query
- Getting week number off a date in MS SQL Server 2005?
- How to display two digits after decimal point in SQL Server
- Include missing months in Group By query
- How to set value to variable using ‘execute’ in t-sql?
- Taking the second last row with only one select in SQL Server?
- SQL Server Maximum rows that can be inserted in a single insert statment
- What is the difference between Cartesian product and cross join?
- How to Bulk Insert from XLSX file extension?
- Count number of records returned by group by