Our company is implementing a new security framework that involves row/column security to our iSeries database. We are seeking to do this at the lowest cost (free), and currently DB2 on the iSeries does not support this. Our current design seeks to build this all in house. We access our database through old applications -- VB and Web. Do you know of any standards that people have developed to make this possible? Or is IBM planning on providing this level of security in the future?
You may have already thought of this, but you can use logical files to limit the views users have of the contents of a database file. In addition, IBM supports two column authorities - reference and update. For more information, see chapter 8 in my book, Experts' Guide to OS/400 Security.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Search400's targeted search engine: Get relevant information on security.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Check out this Search400.com Featured Topic: Top ten security tips
Dig Deeper on iSeries system and application security
Let us know if you find this guide helpful. If you have a topic you'd like to see a user guide on, let us know and we'll do our best to provide you with it.
Related Q&A from Carol Woodbury
Before changing password levels and upgrading operating systems on the AS/400, ensure the clients connecting to the NetServer do not need the old ... Continue Reading
Look in the audit journal (QAUDJRN) on the AS/400 for an authority failure message with the name of the library as the object name. Use the ... Continue Reading
The UPPWEI field corresponds to the password expiration interval field, and its values "0" and "-1" represent the *SYSVAL and *NOXMAX commands. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.