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 Thursday, March 18, 2004 6:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 9, 2009 4:45 AM
Points: 3, Visits: 49

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

Post #106810
Posted Thursday, March 18, 2004 7:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 259, Visits: 711
Sure -- I'm glad you've found it useful


Post #106844
Posted Thursday, March 18, 2004 8:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 259, Visits: 711
Maybe you can post it in the free downloads section.


Post #106995
Posted Thursday, March 18, 2004 8:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 259, Visits: 711

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.




Post #106996
Posted Friday, March 19, 2004 3:09 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 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
Post #107020
Posted Friday, March 19, 2004 3:29 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

where is the free downloads section ?

i've just had a look for it and can't find it ...




cheers

dbgeezer
Post #107022
Posted Friday, March 19, 2004 6:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 259, Visits: 711
Under Resources >> Products and Books >> Contribute Freeware (This just sends a message to articles@sqlservercentral.com) and the site owners will post it.


Post #107049
Posted Wednesday, March 24, 2004 1:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 25, 2008 10:21 PM
Points: 15, Visits: 10

Yeah!  I do remember reading that in the docs.  My bad.  That was it - the SQL client, they forget to add that to my new hard drive image.  I have it back and the app works!  Thanks!  You rock!

 

~Chuck

 

 

I had it working and it rocked...then my company upgraded my pc from NT workstation to XP and now I get this error when I try to select a server from DumpSQLSec's Report menu:

Run-time error '429':
ActiveX component can't create object
 
I am pulling my hair out trying to solve this as I really want to use this tool again.  Any and all help is greatly appreciated.
 
Chuck Boyce
info@ChuckBoyceTechnology.com



Post #108069
Posted Thursday, March 25, 2004 7:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:42 AM
Points: 259, Visits: 711
Do you have the SQL 2000 client tools loaded on your new machine?


Post #108374
Posted Thursday, January 13, 2005 1:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 4, 2010 9:59 AM
Points: 137, Visits: 14
 One great Tool!!!


-JG
Post #155470
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse