Using R009505 to Update Data Selection Security

The data selection security records are stored in the security table as security type 5. You can use the R009505 batch application to clean up any existing security type 5 records.

The R009505 runs over the F00950 table with data selection on records of Security Type 5 (Processing Option and Data Selection Security). These records must have a value in the Object Name field that is a batch application or *ALL (since Security Type 5 can be set up for interactive application objects as well, those will be ignored by this batch application.) The batch application can be run in Proof or Final Mode where Final Mode will update the F00950 table records according to the values in the processing options. The F00950 table will be updated as follows given the processing option values:

PO	Y or N	Actual Record
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	Y Y Y Y	Y Y Y Y
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	N Y Y Y	N N N N
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	N N Y Y	N N N N
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	N N N Y	N N N N
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	N N N N	N N N N
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	Y N N N	Y N N N
Prompt for Data Selection Full Access Data Selection Modify Data Selection Add Data Selection	Y Y N N	Y Y Y Y