Post reply

Dump SQL Permissions

  • March 15, 2004 at 6:17 pm

    #160651

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

  • March 17, 2004 at 2:33 am

    #499082

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

    If you want it let me know.

    Steve

    cheers

    dbgeezer

  • March 17, 2004 at 7:33 am

    #499114

    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

  • March 17, 2004 at 8:12 am

    #499121

    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

  • March 17, 2004 at 9:23 am

    #499145

    This is one sweet little tool.  Very nice

  • March 17, 2004 at 11:00 am

    #499167

    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.

     

  • March 17, 2004 at 11:57 am

    #499180

    Very, very nice utility. Kudos!

  • March 17, 2004 at 12:52 pm

    #499188

    This is awsome, thanks for the valuable tool!

  • March 17, 2004 at 12:57 pm

    #499189

    Sweet tool!

     

    Thanks...

  • March 18, 2004 at 2:36 am

    #499271

    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.

  • March 18, 2004 at 6:18 am

    #499300

    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

  • March 18, 2004 at 7:40 am

    #499327

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

  • March 18, 2004 at 8:12 pm

    #499439

    Maybe you can post it in the free downloads section.

  • March 18, 2004 at 8:22 pm

    #499440

    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.

  • March 19, 2004 at 3:09 am

    #499457

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy