Scripting out permissions for stored procedures...

microsoft.public.sqlserver.programming

23 Sep 2005 12:56 AM

Brett Davis

Hello,

I want to be able to script out the permissions on my stored procedures e.g.
the GRANT EXECUTE statement but NOT the stored procedures themselves. I
noticed in EM that you can script the objects and INCLUDE the permissions on
the stored procedures... but I want to be able to generate a script that
contains only the permissions granted to the stored procedures. Is this
possible?

I am using SQL Server 2000.

Please advise...

Thank you,

Brett

23 Sep 2005 4:27 AM

Jerry Spivey

Brett,

Sure. Ctrl-click to select the various stored procedures when scripting
them out in EM then uncheck the boxes to script the CREATE and DROP
statments and check the box to script out the object-level permissions.

HTH

Jerry
Show quote

"Brett Davis" <bdavis***@cox.net> wrote in message
news:O4hrlm9vFHA.1012@TK2MSFTNGP09.phx.gbl...
> Hello,
>
> I want to be able to script out the permissions on my stored procedures
> e.g. the GRANT EXECUTE statement but NOT the stored procedures themselves.
> I noticed in EM that you can script the objects and INCLUDE the
> permissions on the stored procedures... but I want to be able to generate
> a script that contains only the permissions granted to the stored
> procedures. Is this possible?
>
> I am using SQL Server 2000.
>
> Please advise...
>
> Thank you,
>
> Brett
>
>