Any nice 3rd party tools to audit other than onaud

Posted in 2011

Topics: Security, Permissions & Auditing

Jonathan — Wed, 30 Mar 2011 19:01:30 — source: IIUG Forums & Mailing Lists

Good afternoon, I'm in a situation where I need to be proactive with auditing of schema changes in my ERP app that utilizes Informix. We have lots of changes with table schema all the time and I was wondering if anyone is using something other than onaudit to track changes to table schema? Thanks for any recommendations or suggestions. Sincerely, Jonathan B. Smaby<http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=1000008613412 48> Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu http://wwww.facebook.com/JonathanSmaby ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

↪ replying to Jonathan

Art Kagel — Wed, 30 Mar 2011 20:02:14 — source: IIUG Forums & Mailing Lists

AGS's Server Studio can snapshot your schemas and can compare schema to schema, stored schema to live database, database to database, server to server and report differences or generate sync scripts. If you also use AGS's Sentinel you can schedule periodic snapshots of the database schemas to run hourly/daily/etc. and Sentinel will keep all of the snapshots in its repository. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 30, 2011 at 3:01 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Good afternoon, > > I'm in a situation where I need to be proactive with auditing of schema > changes in my ERP app that utilizes Informix. We have lots of changes with > table schema all the time and I was wondering if anyone is using something > other than onaudit to track changes to table schema? > > Thanks for any recommendations or suggestions. > > Sincerely, > > Jonathan B. > Smaby< > http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=100000861341248 > > > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > http://wwww.facebook.com/JonathanSmaby > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf307c9c3c914146049fb8a6d0

↪ replying to Jonathan

Mark Jamison — Wed, 30 Mar 2011 21:33:37 — source: IIUG Forums & Mailing Lists

IBM Guardium isn't strictly 3rd party, and may be overkill for just ddl auditing, but it fit the bill capturing everything you listed below, and it works great with Informix, with a roadmap to provide even more Informix support. Sent from my iPad On Mar 30, 2011, at 2:01 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu> wrote: > Good afternoon, > > I'm in a situation where I need to be proactive with auditing of schema > changes in my ERP app that utilizes Informix. We have lots of changes with > table schema all the time and I was wondering if anyone is using something > other than onaudit to track changes to table schema? > > Thanks for any recommendations or suggestions. > > Sincerely, > > Jonathan B. > Smaby<http://www.facebook.com/photo.php?pid=392289&l=a2b304ccd3&id=1000008613412 48> > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > http://wwww.facebook.com/JonathanSmaby > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Art Kagel

Knox, Ernest — Wed, 30 Mar 2011 23:43:00 — source: IIUG Forums & Mailing Lists

I currently use a script to dump the DB schema every couple of days, then I can go back to diff them for possible changes. This is very crude, but cheap. Will AGS's Server Studio perform much better job at this and can it track who/userid did perform the change(s)? Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com =20 " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Wednesday, March 30, 2011 4:02 PM To: ids@iiug.org Subject: Re: Any nice 3rd party tools to audit other th.... [23251] AGS's Server Studio can snapshot your schemas and can compare schema to=20 schema, stored schema to live database, database to database, server to=20 server and report differences or generate sync scripts. If you also use=20 AGS's Sentinel you can schedule periodic snapshots of the database schemas=20 to run hourly/daily/etc. and Sentinel will keep all of the snapshots in its=20 repository.=20 Art=20 Art S. Kagel=20 Advanced DataTools (www.advancedatatools.com)=20 Blog: http://informix-myview.blogspot.com/=20 Disclaimer: Please keep in mind that my own opinions are my own opinions and=20 do not reflect on my employer, Advanced DataTools, the IIUG, nor any other=20 organization with which I am associated either explicitly, implicitly, or by=20 inference. Neither do those opinions reflect those of other individuals=20 affiliated with any entity with which I am affiliated nor those of the=20 entities themselves.=20 On Wed, Mar 30, 2011 at 3:01 PM, Jonathan Smaby=20 <Jonathan.Smaby@pomona.edu>wrote:=20 > Good afternoon,=20 >=20 > I'm in a situation where I need to be proactive with auditing of schema=20 > changes in my ERP app that utilizes Informix. We have lots of changes with=20 > table schema all the time and I was wondering if anyone is using something=20 > other than onaudit to track changes to table schema?=20 >=20 > Thanks for any recommendations or suggestions.=20 >=20 > Sincerely,=20 >=20 > Jonathan B.=20 > Smaby<=20 > http://www.facebook.com/photo.php?pid=3D392289&l=3Da2b304ccd3&id=3D10000086= 134 1248=20 > >=20 > Pomona College=20 > phone: (909) 621-8506=20 > email: jonathan.smaby@pomona.edu=20 > http://wwww.facebook.com/JonathanSmaby=20 >=20 > -------------------------------------------------------------=20 > This message has been scanned by Postini anti-virus software.=20 >=20 >=20 >=20 >=20 ************************************************************************ *******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --20cf307c9c3c914146049fb8a6d0=20 ************************************************************************ *******=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

↪ replying to Knox, Ernest

Art Kagel — Thu, 31 Mar 2011 00:48:24 — source: IIUG Forums & Mailing Lists

Yes, better, no it cannot tell who made the changes. Art On Mar 30, 2011 7:43 PM, "Knox, Ernest" <Ernest.Knox@searshc.com> wrote: > I currently use a script to dump the DB schema every couple of days, > then I can go back to diff them for possible changes. This is very > crude, but cheap. > > Will AGS's Server Studio perform much better job at this and can it > track who/userid did perform the change(s)? > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > =20 > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Wednesday, March 30, 2011 4:02 PM > To: ids@iiug.org > Subject: Re: Any nice 3rd party tools to audit other th.... [23251] > > AGS's Server Studio can snapshot your schemas and can compare schema to=20 > schema, stored schema to live database, database to database, server to=20 > server and report differences or generate sync scripts. If you also use=20 > AGS's Sentinel you can schedule periodic snapshots of the database > schemas=20 > to run hourly/daily/etc. and Sentinel will keep all of the snapshots in > its=20 > repository.=20 > > Art=20 > > Art S. Kagel=20 > Advanced DataTools (www.advancedatatools.com)=20 > Blog: http://informix-myview.blogspot.com/=20 > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and=20 > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other=20 > organization with which I am associated either explicitly, implicitly, > or by=20 > inference. Neither do those opinions reflect those of other individuals=20 > affiliated with any entity with which I am affiliated nor those of the=20 > entities themselves.=20 > > On Wed, Mar 30, 2011 at 3:01 PM, Jonathan Smaby=20 > <Jonathan.Smaby@pomona.edu>wrote:=20 > >> Good afternoon,=20 >>=20 >> I'm in a situation where I need to be proactive with auditing of > schema=20 >> changes in my ERP app that utilizes Informix. We have lots of changes > with=20 >> table schema all the time and I was wondering if anyone is using > something=20 >> other than onaudit to track changes to table schema?=20 >>=20 >> Thanks for any recommendations or suggestions.=20 >>=20 >> Sincerely,=20 >>=20 >> Jonathan B.=20 >> Smaby<=20 >> > http://www.facebook.com/photo.php?pid=3D392289&l=3Da2b304ccd3&id=3D10000086= > 134 > 1248=20 >> >=20 >> Pomona College=20 >> phone: (909) 621-8506=20 >> email: jonathan.smaby@pomona.edu=20 >> http://wwww.facebook.com/JonathanSmaby=20 >>=20 >> -------------------------------------------------------------=20 >> This message has been scanned by Postini anti-virus software.=20 >>=20 >>=20 >>=20 >>=20 > ************************************************************************ > *******=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20 >>=20 >>=20 > > --20cf307c9c3c914146049fb8a6d0=20 > > ************************************************************************ > *******=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 > > This message, including any attachments, is the property of Sears Holdings = > Corporation and/or one of its subsidiaries. It is confidential and may cont= > ain proprietary or legally privileged information. If you are not the inten= > ded recipient, please delete it without reading the contents. Thank you. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --20cf307f3292e77dd8049fbca5f4