View this email as a Web page Please add System iNetwork Systems Management to your Safe Sender list.

System iNetwork
System iNetwork Systems Management
Issue 229
November 18, 2009
Bytware StandGuard Security
Bytware
StandGuard Security Are you monitoring and auditing your System i security? StandGuard Security helps you meet the demands for accountability and security of sensitive data with a comprehensive software package that combines three critical security tools: Exit Point Monitoring; Security Audit; and QAUDJRN Monitoring. Try it free for 30 days!

Detecting Access to your Sensitive Database Files
By Dan Riehl

Do you know if your system users are accessing files that are outside their scope of responsibility? You can journal those sensitive files and report on who has made changes to the records, but it's a bit different if you want to know who looked at the files, but did not make any changes.

In our highly regulated environment, we must be able to detect who is looking at the sensitive files. For example, should members of the IT staff be looking at the PAYROLL file? Should our business analysts be viewing any sensitive data? What are the limits? Where is the segregation of Duties? What is the state of our PCI compliance? Are we compliant with state privacy laws? Unless you have a way to audit who is looking at your sensitive files, it's a difficult state.

If you want to be able to detect the use of a sensitive file on your system, you can use the object auditing feature of the OS. To do this, you must first configure your system for object auditing. *Read More...


Patrick Townsend
Patrick
Townsend PATRICK TOWNSEND SECURITY SOLUTIONS
"the System i encryption company"

Simplify your compliance issues with PCI, HIPAA, Sox, and state data privacy laws with our:

  • Complete data security solutions
  • Informative webinars, whitepapers & videos
  • and more!


  • Download our latest webinar: Top 10 Encryption Pitfalls How to Get Encryption Right and Keep Your Name Out of the Headlines
    System iNetwork
    HouseAd
eNL The Essential Collection: Security
    Be Sure You Can Recover Your Security Information, Keep Your Service Tools Secure, Securing System i Access for Web, and more in this collection of Security articles. Download eBook here!

    IBM ITSO RedBook Pages Now available on Facebook, Twitter and RSS Feed
    By Dan Riehl

    IBM Redbooks are a great learning tool when you want real depth and practical instruction and know-how on technical topics. IBM maintains the IBM Redbooks System i Portal that contains hundreds of Redbooks and smaller RedPieces that you can freely access and download. The general IBM Redbook Portal provides access to all platform Redbooks.

    Ihe ITSO(IBM's International Technical Services Organization) has now created their own social networking Redbook sites. So now you can follow the Redbooks on Facebook and Twitter.

    *Read More...

    Carsten's Corner: Query/400 Profile Options and the SETQRYPRFO Command
    By Carsten Flensburg

    While the Query/400 product is an old work horse heading for retirement, it is still widely used in many shops around the world. For this reason, and even as more contemporary query and BI products are taking over, it is important to emphasize that as long as Query/400 is installed on a system it calls for consideration both in terms of operational and security aspects.

    In order to address some of these requirements Query/400 has over time been subject to a number of enhancements delivered by means of special data areas.

    In this article I provide a new command that brings all these special data areas into one easy to use command interface.

    *Read More...


    On the Web

    An IBM i Tale for the Ages . . . Everyone is raving this week about Origin of Servers, a short work of IBM i-related fiction that Joe Kennedy wrote in honor of National Novel Writing Month:

    This is just too cool a story not to share with everyone you know. Perhaps some of our colleagues who don't remember the System/3 or System/38 will read it and wonder, "Could some of this stuff actually be true?" Nice work, Mr. Kennedy!

    brilliant writing, Joe. I don't know whether to call this truly great science fiction or horror. It's so true it's scary!

    Quite a story! :) A quick read during a quiet moment, a quintessential tale for us professionals, not a queasy moment in the whole story. Query isn't mentioned, but that isn't required. I didn't quit until it was over

    If you haven't yet read Joe's Origin of Servers tale, check it out now in the Industry Bits blog on System iNetwork.com.


    Sign Up for Other System iNetwork Newsletters!
    Enter Your E-mail Address:

    System iNetwork Programming Tips Technical tips for System i software analysts and developers, which is sent the second and fourth Thursdays of each month.

    NEWS Daily System i-related news and announcements Monday – Thursday.

    My i & .NET Monthly e-mail newsletter presenting technical articles, how-to guides, tips, and case studies on the integration of .NET applications.

    RPG Coder Technical tips and techniques for RPG programmers and developers, which is sent on the 1st and 3rd Thursday of each month.

    Sign-up form doesn't work? Subscribe at System iNetwork.com

    Thank you to our sponsors:
    Bytware StandGuard Security
    Patrick Townsend

    sponsorArray[1].sponsorName

    sponsorArray[2].sponsorName

    sponsorArray[3].sponsorName

    From System iNetwork
    White Papers

    Implementing an ERP System
    Maybe your organization's operational model has changed, or your existing systems are reaching end of life. In these cases, a new Enterprise Resource Planning (ERP) system will prepare your company for the future and give it the competitive edge it may need for the next decade. Read the complete article here.



    Contact Unsubscribe Advertise Submit Press Release

    You are subscribed as: #email# (not #email# ? Subscribe Now.)

    To unsubscribe from this email please click here.

    For questions, comments, or reader feedback about an item covered in System iNetwork Systems Management Tips, or if you have a technical question, please email Dan Riehl, System iNEWS technical editor. You can also post technical questions in the SystemiNetwork.com forums.

    Copyright 2009 | System iNetwork | Penton Media | 221 E 29th St. | Loveland, CO 80538 | Privacy Policy

    "System i" is a trademark of International Business Machines (IBM) Corporation and is used by Penton Media, Inc., under license. System iNEWS, SystemiNetwork.com, and the SystemiNetwork.com newsletters are published independently of IBM, which is not responsible in any way for the content. Penton Media, Inc., is solely responsible for the editorial content and control of System iNEWS, SystemiNetwork.com, and the SystemiNetwork.com newsletters.