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

2003-12-30

188 reads

Blogs

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Friday Flyway Tips: Autopilot in 10 minutes

By

The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Read the latest Blogs

Forums

No End to Programmers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No End to Programmers

Solution to a problem without using a CURSOR

By krishnagceb

Hi there to all SQL gurus So, here is the scenario. I have a...

Error when running sql server backup routine job

By Jeco

Guys, I am facing problems when running a backup routine JOB in SQL Server,...

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers