SV-251619r961158_rule
V-251619
SRG-APP-000251-DB-000160
IDMS-DB-000480
CAT II
10
For SQL-defined tables, ALTER TABLE <schema-name>.<table-name> ADD CHECK (search-condition).
For network-defined records, MODIFY <record-name> CALL procedure BEFORE STORE/MODIFY. Create or update procedure to validate provided record field values.
Other applications and front-ends using mapping can use the automatic editing feature and edit and code tables to verify that an input value is valid.
Validate SQL-defined tables, DISPLAY TABLE <schema-name>.<table-name> . If there is not a CHECK for the columns and accompanying accepted values, this is a finding.
Validate network-defined records, DISPLAY SCHEMA or DISPLAY RECORD. If there is no CALL to a procedure BEFORE STORE and BEFORE MODIFY, this is a finding.
If the procedure does not validate the non-exempt columns, this is a finding.
Other applications and front-ends using mapping can use the automatic editing feature and edit and code tables to verify that an input value is valid.
V-251619
False
IDMS-DB-000480
Validate SQL-defined tables, DISPLAY TABLE <schema-name>.<table-name> . If there is not a CHECK for the columns and accompanying accepted values, this is a finding.
Validate network-defined records, DISPLAY SCHEMA or DISPLAY RECORD. If there is no CALL to a procedure BEFORE STORE and BEFORE MODIFY, this is a finding.
If the procedure does not validate the non-exempt columns, this is a finding.
Other applications and front-ends using mapping can use the automatic editing feature and edit and code tables to verify that an input value is valid.
M
5418