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

  • Re: logs on RAID 0
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... If any Newsgroup admins review these postings, ...
    (microsoft.public.sqlserver.setup)
  • Re: whats in those Tlogs backups?
    ... Did you try the RESTORE WITH HEADERONLY or FILELISTONLY as Tibor suggested? ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ... >>> indexdefrag ...
    (microsoft.public.sqlserver.server)
  • Re: Packing on data table.
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... images/pdf documents/OLE Objects). ...
    (microsoft.public.sqlserver.programming)
  • Re: Server connection to SQL/Server Express wont work
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... Rick Byham (MSFT) ...
    (microsoft.public.sqlserver.connect)
  • Re: Why a DELETE transaction running in read-uncomitted is acquiri
    ... You can have parts of the Delete statement run in uncommitted isolation mode such as joining on other tables to find the rows etc. ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ...
    (microsoft.public.sqlserver.server)