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 220
July 01, 2009
Symtrax
Symtrax Compleo Suite reformats spool data/outputs directly from within the ERP spool file/output device system converting them to PC Formats such as excel. Large reports can be broken into perfectly formatted smaller ones, enriched with external data and graphics and the process can be fully automated. Join us for a Live Webinar that demonstrates the power and simplicity of Compleo Suite. JOIN NOW

Properly Securing the QSYSOPR Message Queue
By Dan Riehl

Where did the QSYSOPR messages go?
Who answered that inquiry message?

Often we see users answering messages on the QSYSOPR message queue. Sometimes they respond correctly, sometimes they don't. Remember displaying the QSYSOPR message queue to see what has been happening on your system only to see an empty QSYSOPR message queue.

All of us need to secure the QSYSOPR message queue correctly. It is the message console for the entire system.

Users need to be able to send messages to QSYSOPR, but not answer messages. For that they need Data *ADD and *OBJOPR rights to the queue...

*Read More...

NEWS on i
HouseAd
eNL NEWS on i -- Not just any news -- Chris Maxcer breaks it down for you with easy-to-digest news, announcements, and trends. Featuring a twice monthly podcast and MAXED OUT blog excerpts and reader comments -- this is one newsletter that has it all! Click here

Easily Suppress Adopted Authority with MODINVAU
By Dan Riehl

There are times when we need to allow a user to perform a function that is beyond their authority level. For example, I have a menu option that displays certain selected information from a customer credit file. It shows the Customer name and address, but it does not display any of the sensitive data in the credit file.

In this example, the user should have no authority to access the file. But, when executing this particular menu option to view the Customer Name and Address, I need to elevate the user's authority to allow the user to access the file. The typical method used to elevate the user's authority would be to use Adopted Authority.

We have discussed Adopted authority on numerous occasions in the newsletter, and will not go into the details here. But, if you missed those articles, here is a recent article on how Adopted Authority works.

When a program is executed that adopts authority, that adopted authority will be propagated to all programs that are subsequently called, until the original program that adopted authority is ended.

Another way to look at this is that Adopted authority is passed down the program call stack to all called programs and subprograms. Each of these programs will ultimately RETURN to the CALLing program. When the program that adopted authority RETURNs, the adopted authority is removed.

It is a common misconception that there is only one way to stop the propagation of authority to a called program. That method is implemented by using the USEADPAUT(*NO) program attribute in a called program.

If a program in the Call Stack has adopted authority, and a program is then called that specifies USEADPAUT(*NO), that program, and any programs that it CALLs will not use the adopted authority established earlier in the Call stack. It is a great way to stop the propagation of adopted authority. In this case, the adopted authority established in one program is propagated to a CALLed program, but the CALLed program says 'I don't want to use any adopted authority'.

There is another way to stop the propagation of adopted authority, but using this method, a program that adopts authority can say to a CALLed program, "I've got adopted authority, but you can't have it".

In essence, if a program is running under adopted authority, that program can change its own runtime attributes to either propagate or NOT propagate the adopted authority that is present at its call level.

*Read More...

File Server Vulnerabilities to your Data and Applications
By Dan Riehl

The i/OS Host File Server and Netserver facilities present severe vulnerabilities to your production database and applications. When your system ships from IBM, the File server is configured to be easy to use, but, vulnerable. So, it is up to you to learn how to protect the system and then to make the required changes.

There are several file sharing methods that can be implemented on i/OS. You can use iSeries Access file sharing to navigate through the IFS(Integrated File System) to locate a stream file, directory, or other object. This is typically done using the iSeries Navigator "File Systems" option. Using this type of file sharing, you can even navigate through the QSYS.LIB file system, which makes 'Drag and Drop" access available to your production libraries, files, programs, etc.

Another popular method of file serving is to use the built in support for Netserver, where you can use MS/Widows Explorer to "Map a Drive" to a shared directory in the System i IFS.

IBM has tried to make things easy by shipping the system to us with a pre-configured Netserver "Share" directed at the system's /root file system. This is very dangerous.

*Read More...


On the Web

Our new Reader to Reader feature lets you share your IBM i code, comments, discoveries, and solutions to problems. Email your contributions of 500-1400 words to editors@systeminetwork.com. Please include your full name and email address. We edit submissions for style, grammar, and length. Submissions could appear on our website or in our print magazine. If we use your submission in the print magazine, you'll get $50.


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 sponsor:
Symtrax

sponsorArray[1].sponsorName

sponsorArray[2].sponsorName

From System iNetwork
Demo Booth - LIVE!

Replay -- Improving the Bottom Line: Automated A/P Processing Saves Time and Money!
Learn how to save money and increase productivity by automating accounts payable and other business processes.

Replay -- Developing a Web and Windows Reporting and Analysis Application on the IBM i
See how NGS-IQ lets you create attention-getting Web reports, dashboards, spreadsheets, and more from your database directly from the IBM i.


e-Learning
July 30 – Introduction to XML & Web Services for System i Developers
This course covers the basics of XML syntax, how XML and web services fit into the larger topic of browser-based application development, and more.

July 30 – Introduction to SQL for System i Developers
This course covers the essential components of SQL syntax, as well as iSeries/System i support for SQL. Register now!


Contact Unsubscribe Advertise Submit Press Release

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

To unsubscribe from this e-mail 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 e–mail 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.