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 40 total)

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