1. Security Administration Guide
  2. Activating Inclusive Row Security

Activating Inclusive Row Security

The system assumes Exclusive Row Security unless you specify inclusive row security.

Use these steps to activate inclusive row security:

  1. Enter P00950 in the Fast Path to access the Security Workbench.

  2. On the Work With User/Role Security form, select Exclusive/Inclusive from the Form menu.

  3. On the Inclusive/Exclusive Row Security form, select the Inclusive Row Security option.

  4. Click OK.

If your system is prior to JD Edwards EnterpriseOne Tools Release 8.9, you must manually enter a record in the Security Workbench table using SQL to indicate to your system that inclusive row security is to be used. Use this Insert SQL statement as an example:

Insert into SYS7333.F00950 (FSSETY, FSUSER, FSOBNM, FSDTAI, FSFRDV, 
FSSY, FSATN3) Values(' ','EXCLUSIVE',' ', ' ', ' ', ' ' , '1')