Re: Script SQL2005 Security?
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Sat, 18 Aug 2007 12:04:41 -0400
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
.
- Prev by Date: Re: Changing Query behavior based on local vs. remote context?
- Next by Date: Re: db_ddladmin rights in Management Studio
- Previous by thread: Changing Query behavior based on local vs. remote context?
- Next by thread: Re: db_ddladmin rights in Management Studio
- Index(es):
Relevant Pages
|
|
