Dump SQL Permissions

  • cmille19

    SSCertifiable

    Points: 5920

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/cmiller/dumps

  • SteveB-74825

    Hall of Fame

    Points: 3290

    I have some C# code that dumps table defs and permissions using DMO.

    If you want it let me know.

    Steve

    cheers

    dbgeezer

  • Rudy Panigas

    SSChampion

    Points: 10695

    Excellent!! Works very nicely Do you have any code that will dump(to a file) all user permission, writes, etc so that once I create another database on differenet server (test environment) I can reload the file and it would automatically load all users and ther permissions, passwords, etc??

     

    Thanks and again, excellent work!

     

    Rudy

  • lansley

    Ten Centuries

    Points: 1055

    Well, I've been looking for a reason and an opportunity to familiarize myself a little on DMO.  This seems like a useful tool that I can employ on a current project, so I think this is the opportunity.

    Thanks.


    Larry Ansley
    Atlanta, GA

  • JohnMarks

    Ten Centuries

    Points: 1113

    This is one sweet little tool.  Very nice

  • dlmontgomery

    SSC Enthusiast

    Points: 140

    I'm definitely gonna take a look at this, but I'm wondering...

    Can this tool (or another other tool/script/sproc) show a "last logged in" date?

    Always trying to determine if a particular user is "active" or not.

     

  • James Luetkehoelter

    SSCommitted

    Points: 1733

    Very, very nice utility. Kudos!

  • andersg98

    SSCertifiable

    Points: 5168

    This is awsome, thanks for the valuable tool!

  • jrotan

    SSC Enthusiast

    Points: 192

    Sweet tool!

     

    Thanks...

  • Yoshihiro Kawabata-127513

    SSC Enthusiast

    Points: 117

    Cool Tool
     
    My friend translate this to Japanese.
    I want to publish Japanese Edition in our community PASSJ ?
    Can I do it ?
     

    out community: PASSJ

    PASSJ is Professional Association for SQL Server Japan.

    I'm a PASSJ dicector, and security-board leader.

    I already introduce DumpSQLSec in my BLog by Japanese.

     DumpSQLSec (Tools for output Security Setting to Excel)

    Regards.
  • Argyle-123241

    SSC Veteran

    Points: 233

    Here is a script that does what you are looking for:

    http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=298

  • cmille19

    SSCertifiable

    Points: 5920

    Sure -- I'm glad you've found it useful

  • cmille19

    SSCertifiable

    Points: 5920

    Maybe you can post it in the free downloads section.

  • cmille19

    SSCertifiable

    Points: 5920

    Unfortunately I don't -- but that's not a bad idea for another tool. Perhaps someone else has created one. I've been sitting on DumpSQLSec for three years and I bet quite a few DBAs have some cool SQL-DMO code out there. Let's start posting it.

    On seperate note, creating a SQL-DMO applicaton is a great way for DBAs to brush up on their programming skills. I plan on creating a .NET SQL-DMO application sometime this year in order to start learning .NET and of the course there's the added benefit of having yet another useful tool.

  • SteveB-74825

    Hall of Fame

    Points: 3290

    I have some code written in C# that dumps all users, table defs, and permissions to local files on disk.

    The code installs as a service and would only need a tweak to read the server name from a file or a registry setting. I'll post the code on here if anyone is interested and they can amend it and use it as they see fit.

     

    cheers

    dbgeezer

Viewing 15 posts - 1 through 15 (of 41 total)

You must be logged in to reply to this topic. Login to reply