Remove Exec Permissions To Extended Stored Procs

I created this script to simplify the process of restricting access to high risk extended stored procedures. It will find any user or role which has execute permissions on any of the stored procedures in the "#High_Risk_Stored_Procs" temp table and will generate the relevant revoke statements to remove those permissions.The current list of stored procedures […]

5 (1)

2006-11-27 (first published: )

376 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

SQL Query Assistance Required

By troy1w1w

Hi. I am wanting to know if there is a way to make this...

Stairway to Database Containers Level 3: Building Custom Container Images by Hand

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Stairway to Database Containers Level...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers