Adding Row Security

Enter P92001 in the Fast Path.

1. On Work With Data Items, click Find.

   Note: You can enter search criteria in the Search Description field and the query by example (QBE) row to narrow your search.

2. Select the data item that you want to secure, and click Select.

   The Data Item Specifications form appears.

3. On the Item Specifications tab, select the Row Security option and click OK.

   This option must be selected for row security to work.

4. Click OK.

5. Exit the data dictionary application.

6. In Solution Explorer, enter P00950 in the Fast Path and press Enter.

7. On the Work With User/Role Security form, select the Form menu, Set Up Security, Row.

8. On the Row Security form, complete the User / Role field and then click Find to display current row security.

9. Complete these fields, either in the first open detail area row (to add security) or in a pre-existing detail area row (to change security):

   • Table

     You can enter *ALL in this field.

   • Data Item

     This field is required.

   • From Value

     This field is required.

   • Thru Value

   • Add

   • Change

   • Delete

   • View

10. Click OK to save the security information.