Post reply

Sarbanes and Oxley (SOX) security reports

  • February 16, 2004 at 9:02 am

    #81996

    Any one have a script(s) of how pull all logins, related users, and rights to all databases?  I am trying to put this together for Sarbanes Oxley audit.  Any one else working on this?

     

     

    Thanks,

    Joseph Devereaux

  • February 17, 2004 at 9:01 am

    #494383

    I wrote a script several years ago that might help, I wrote it for 6.5 for the swynk.com site. <g>

    Anyway, it's at http://www.databasejournal.com/scripts/article.php/1546401, I hope it helps.  You'll need to do a search/replace on the script to change double quotes to single quotes, it seems to work under 2000, it creates a view that you can then select from and do whatever you want.

    Good luck!

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • February 17, 2004 at 9:19 am

    #494389

    Thanks, that helped on the object side.  I am also looking for one that would display something like:

     

    Sid, UserName, DatabaseName, Server Role, Database Role, ect.

    When I figure out some/part of it I will post it here.

    Thanks again,

    Joseph Devereaux

  • February 17, 2004 at 9:37 am

    #494393

    FYI, added a Sarbannes Oxley forum.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • February 17, 2004 at 9:39 am

    #494394

    Sorry, I don't have a quick answer for what you're looking for.  All I can suggest is that there is a world of information looking at the system tables and within the Master DB.  The information is there, it's just a matter of constructing the right views to retrieve it.

    Good luck!  I hope you'll share your solution when you get one.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • February 17, 2004 at 9:46 am

    #494396

    Thanks Steve for the new group. 

    If/when I get this other query figured out I will post it.

     

    thanks

     

     

Viewing 6 posts - 1 through 5 (of 5 total)

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