Re: Script SQL2005 Security?



See if this helps:

http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm



--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"KevinL" <KevinL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:57F00481-C3D9-46C9-B257-0937AD8A6024@xxxxxxxxxxxxxxxx
I'm attempting to script DB Level security (roles and object level perms) on
a Development DB so that I can re-apply it after I restore the DB from
another (Production) server. I have done this many times on SQL2000, but
have not been able to find a way to accomplish it with Management Studio (or
manually with System Views).

Can anyone shed some light? Thanks.
--
Kevin

.



Relevant Pages