CODEWITHSUNDEEP
sql-serversql-server-2005
dsteele
dsteele

Reputation: 1272

SQL Server 2005 Express other users can't see stored procedures

I added a couple of stored procedures to a SQL Server 2005 database at our company. The database uses Windows Authentication. Other users cannot see the procedures, although they can view the database/tables/stored procedures using SQL Server Management Express. What am I missing?

Upvotes: 2

Views: 1169

Answers (1)

Jose Basilio
Jose Basilio

Reputation: 51548

Make sure you grant execute permissions to the SPs:

GRANT EXECUTE ON [sp name] TO [user/role]

Upvotes: 7

Related Questions