Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Dump SQL Permissions Expand / Collapse
Author
Message
Posted Monday, March 15, 2004 6:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:01 AM
Points: 258, Visits: 701
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/cmiller/dumps


Post #106286
Posted Wednesday, March 17, 2004 2:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 27, 2007 12:21 PM
Points: 342, Visits: 1

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

If you want it let me know.

Steve




cheers

dbgeezer
Post #106535
Posted Wednesday, March 17, 2004 7:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:14 PM
Points: 312, Visits: 1,106

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!

 




Post #106577
Posted Wednesday, March 17, 2004 8:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 7:46 AM
Points: 265, Visits: 36

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
Post #106588
Posted Wednesday, March 17, 2004 9:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 25, 2014 12:10 PM
Points: 64, Visits: 476
This is one sweet little tool.  Very nice


Post #106615
Posted Wednesday, March 17, 2004 11:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 20, 2007 2:55 PM
Points: 2, Visits: 1

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.

 




Post #106643
Posted Wednesday, March 17, 2004 11:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 6, 2011 8:20 PM
Points: 227, Visits: 33
Very, very nice utility. Kudos!


Post #106658
Posted Wednesday, March 17, 2004 12:52 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:04 PM
Points: 2,127, Visits: 747
This is awsome, thanks for the valuable tool!


Post #106671
Posted Wednesday, March 17, 2004 12:57 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, June 11, 2005 5:52 PM
Points: 56, Visits: 1

Sweet tool!

 

Thanks...




Post #106672
Posted Thursday, March 18, 2004 2:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 22, 2005 6:00 AM
Points: 1, Visits: 1
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.
Post #106776
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse