Technical Article

GRANT EXEC or SELECT to sprocs, UDFs and views

Based on moffan76's script to GRANT EXEC to all sprocs and UDFs (that EXEC) and GRANT SELECT to views and UDFs (that SELECT).  This script uses that same general technique of selecting the object names from sysobjects, but does it in one step w/o using a cursor.  It is also not wrapped in a sproc […]

You rated this post out of 5. Change rating


186 reads


Friday Flyway Tips–Comparison Options


Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights


giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3


Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs


Exam Ref DP-300 Administering Microsoft Azure SQL Solutions

By Site Owners

Comments posted to this topic are about the item Exam Ref DP-300 Administering Microsoft...


By Louis Davidson (@drsql)

Comments posted to this topic are about the item Love

Drop or delete a existing partition

By Siten0308

Hello, so I was reading on partitioning a large table, Which i successfully did,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers