Blog
i can

Dawn May

Dawn May




Bookmark and Share

September 2014

Sun Mon Tue Wed Thu Fri Sat
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

« Command Retrieve Exit Programs Can Run After Command Completion | Main | Delete That Object »

July 24, 2012

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d83545a5d153ef016768b8029f970b

Listed below are links to weblogs that reference IBM i Security Never Sleeps:

Comments

Is there any way to audit (log) those SQL statements running in interactive STRSQL session?

Good question and one that has been asked by other customers. The closest you can come to "auditing" command interfaces that execute user provided SQL statements is to use STRDBMON with a filter.

I have an article which explains how to do that:
www.ibmsystemsmag.com/ibmi/administrator/db2/SOX-Auditing-of-STRSQL-and-RUNSQLSTM-Commands

Hope that helps.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.