[dba-SQLServer] Securables in SQL Server 2005

Robert L. Stewart rl_stewart at highstream.net
Fri Mar 16 14:07:44 CDT 2007


Here is what I think will be a better solution next time
you have this problem.  This is an SP that you can add to
a database and then run.  You pass in the user/role that
you want to grant EXECUTE rights to and it goes through
the SPs and functions and grants the rights.

At 01:00 PM 3/16/2007, you wrote:
>Date: Fri, 16 Mar 2007 08:15:40 -0500
>From: <Elizabeth.J.Doering at wellsfargo.com>
>Subject: Re: [dba-SQLServer] Securables in SQL Server 2005
>To: <dba-sqlserver at databaseadvisors.com>
><1C2084FD2472124AB1812A5476EA3B7A014836EB at msgswbmnmsp04.wellsfargo.com>
>Content-Type: text/plain;       charset="US-ASCII"
>Thanks so much for replying.  I actually came to the same solution.
>Since, however, I had hundreds to set--and a bunch to unset--I created a
>table with all the objects and who needed permissions on each one.  Then
>I built up all my Grant and Revoke statements in a query, pasted the
>results in a new query window and ran them all at once.  I'm sure there
>were more elegant solutions, but this one did save my fingers--and my

More information about the dba-SQLServer mailing list