Script SQL2005 Security?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KevinL - 17 Aug 2007 17:56 GMT

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.

Signature

Kevin

Reply to this Message

Andrew J. Kelly - 18 Aug 2007 17:04 GMT

See if this helps:

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

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> I'm attempting to script DB Level security (roles and object level perms)
> on
[quoted text clipped - 5 lines]
>
> Can anyone shed some light? Thanks.

Reply to this Message