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

Who Did What? Expand / Collapse
Author
Message
Posted Wednesday, November 24, 2004 10:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 27, 2006 8:43 PM
Points: 2, Visits: 1
With the SOX lock downs on our SQL databases, it appears someone had taken "rights" away from a particular login id that imports data via batch. This login was changed and limited in it's access, however, for the last 2.5 years, it did had the correct rights. Once the problem was identified and fixed (restore rights to the login id), now one is "owning" up to making the change. Where do I go to look at the log files to see who made this change originally?


Post #148065
Posted Monday, November 29, 2004 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #148362
Posted Monday, November 29, 2004 8:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 10:27 PM
Points: 87, Visits: 161

Howzit .

 

SQL doesn't keep these changes in a log as such . You have to design a strategy that will keep the changes for you and when it occurs .

You can use SQL profiler , hence the performance impact - so becarefull what events and couters you choose and also if you can design something that will keep all the entries in your syscacheobjects joined to the sysprocesses table in master you should catch the offender .

 

I have tried to catch a bugger dropping indexes during prod hours by creating a trigger on the syscacheobjects system table but with no -avail ..so I am also in the situasion ..I will keep you informed if I make any progress ...

To all other SQL fundies out there , give your comments , there is two of us now that would like you input in this regard .

 

 

 




Post #148375
Posted Monday, December 20, 2004 10:58 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 8:34 AM
Points: 108, Visits: 6

check out DB Ghost for a solution to database change management. For an excellent read check out this http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

 


regards,
Mark Baekdal
www.dbghost.com

+44 (0)208 241 1762
Living and breathing database change management for SQL Server

 

 

 

Post #151854
Posted Thursday, January 6, 2005 8:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 27, 2014 1:07 PM
Points: 25, Visits: 34

Lumigent Log Explorer is another tool that you can use to capture this type of infoirmation.  It can read and interpret the transaction log files and there is an option to capture user information along with the log entries.  In this case, you can use it to look at the syspermissions table.

http://www.lumigent.com/products/le_sql.html



DBAJames
Post #154040
Posted Wednesday, January 19, 2005 2:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 3, 2006 11:37 AM
Points: 17, Visits: 1

ApexSQL has a good tool read the SQL transaction log. You can capture who did what, when and can audit data and DDL structure. I have found it very cost effective compared to what else is out there.

http://apexsql.com/sql_tools_log.htm

Post #156538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse