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
This was first published in April 2004