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

Sic Transit Gloria Community

By

When Covid took out the PASS organization, I had someone say to me, “Well,...

DATEADD Truncates the Number Parameter: #SQLNewBlogger

By

This was an interesting thing I saw in a Question of the Day submission....

Our SQL Server is Slow! What Do I Do First?

By

Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

ExecutionLog3 table in Reportserver Database

By cooldude001

I have a SSRS report for which users are complaining to be slow, but...

SQL Server Maintenance Plan Feedback

By water490

Hi I set this up today.  I wanted to get some feedback.  I have...

Visit the forum

Question of the Day

Counting Bits IV

What do these two selects return?

SELECT BIT_COUNT (CAST (-1 as smallint))
     , BIT_COUNT (CAST (-1 as bigint))

See possible answers