Bruce McFarlane (@SQLWhat) on Piclur: Is there an effective way to grant a Dev rwx permissions to all stored procs without giving SA priveleges? #SQLHELP / Piclur

Bruce McFarlane

Feb 14, 2012

Is there an effective way to grant a Dev rwx permissions to all stored procs without giving SA priveleges? #SQLHELP

Janos Berke

Feb 14, 2012

@SQLWhat in a normal db use GRANT EXEC ON SCHEMA::dbo TO [user]. replace dbo to your schema. sys dbs are other story #sqlhelp

Robert L Davis

Feb 14, 2012

@SQLWhat GRANT VIEW DEFINITION, ALTER, EXECUTE to [user]; #SQLHELP

United States Trends

1. Comey 65.2K posts
2. Thanksgiving 160K posts
3. Lindsey Halligan 13.7K posts
4. Jimmy Cliff 29.5K posts
5. #WooSoxWishList 6,146 posts
6. Pentagon 11.4K posts
7. DISMISSED 33.6K posts
8. #NutramentHolidayPromotion N/A
9. #IDontWantToOverreactBUT 1,469 posts
10. Department of War 15.2K posts
11. Sen. Mark Kelly 18.5K posts
12. DOGE 246K posts
13. Ja'Kobi Gillespie N/A
14. #MondayMotivation 14.7K posts
15. Hal Steinbrenner N/A
16. #stayselcaday 5,132 posts
17. TOP CALL 5,417 posts
18. AI Alert 3,579 posts
19. Hegseth 19.3K posts
20. Monad 186K posts

Something went wrong.

Something went wrong.