How to audit users of strsql? -- MIDRANGE-L

Subject: How to audit users of strsql?
From: fbocch2595@xxxxxxx
Date: Wed, 20 Jun 2012 09:44:16 -0400 (EDT)
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hi Y'all, for you folks that allow programmers to use strsql, how do you audit them? My interest is in knowing the statements they run and what data is changed via their strsql sessions. Is it possible to force session info to be generated upon their every use of strsql? I'd like to force an sql session upon every strsql usage and then make sure that session can not be deleted. I think there's 3rd party software that will help but we'll go the native OS route for now.

Any suggestions/recommendations?

Thanks, Frank

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: How to audit users of strsql? , Luis Rodriguez
RE: How to audit users of strsql? , Monnier, Gary
RE: How to audit users of strsql? , Paul Fenstermacher
Re: How to audit users of strsql? , rob

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.