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: )

389 reads

Blogs

Daily Coping 5 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

Update table from other tables

By jamesstirling01

Hi, Basically i have 2 tables check-in and check-out where users check-in and check-out...

private messages gone

By frederico_fonseca

hi, Maybe I'm doing something wrong now, but it seems that the option to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers