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?
+6
A:
Make sure you grant execute permissions to the SPs:
GRANT EXECUTE ON [sp name] TO [user/role]
Jose Basilio
2009-04-23 02:54:27
thanks! that got me pointed in the right direction
dsteele
2009-04-23 03:19:24