Limiting Access to Specific Fields of a Database File

You can restrict user update and read requests to specific fields of a physical database file. There are two ways to do this:

• Create a logical view of the physical file that includes only those fields to which you want your users to have access. See Using Logical Files to Secure Data for more information.
• Use the SQL GRANT statement to grant update authority to specific columns of an SQL table. See DB2 UDB for AS/400 SQL Programming Concepts for more information.