Field Level Security

[frankgw@adelphia.net]

Below is some of the information that can be found by going to the IBM On-line Library; searching for manuals containing the word security and then searching on the word "field". Happy surfing! ------------------------------------------------------------- Bookshelf: AS/400 V4R2 Softcopy Library - All Books Bookshelf Book Title; Name; Date; Document Security - Reference V4R2; QB3ALC01; 12/12/97; SC41-5302-01 Field Authorities | Field authorities are now supported for database files. Authorities | supported are Reference and Update. You can only administer these | authorities through the SQL statements, GRANT and REVOKE. You can display | these authorities through the DISPLAY Object Authority (DSPOBJAUT) and the | Edit Object Authority (EDTOBJAUT) commands. You can only display the field | authorities with the EDTOBJAUT command; you cannot edit them. | Changes for field authorities include the following: | The Print Private Authority (PRTPVTAUT) command has new field that | indicates when a file has field authorities. | The Display Object Authority (DSPOBJAUT) command now has *FIELD as a | valid value for the Authority Type parameter. | Information provided by List Users Authorized to Object (QSYLUSRA) API | now has an indication of whether a field has field authorities. | The Grant User Authority (GRTUSRAUT) command will not grant a user's | field authorities. | When a grant with reference object is performed using the GRTOBJAUT | command and both objects (the one being granted to and the referenced | one) are database files, all field authorities will be granted where | the field names match. | If a user's authority to a database file is removed, any field | authorities for the user are also be removed. Just an old mainframer caught in the Web!