'SYSTEM.RADplus_user_roles' SQL Table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Form and Table Documentation (PM)
Scenario 1: "SYSTEM.radplus_user_roles" table - field validations
Specific Setup:
- [UserA] has permissions to access the 'SYSTEM.RADplus_user_roles' table
- [UserA] has access to the "Form and Table Documentation" form
- Have a report [ReportA] created in "Crystal Reports" or any other database program, set to display all the fields in the 'SYSTEM.RADplus_user_roles' table
- Login as [UserA]
Steps
- Open 'Form and Table Documentation' in the 'PM' application
- Set the 'Type of Documentation' to 'Table'
- In the "Table(s) to be Documented" field select the 'SYSTEM.RADplus_user_roles' table
- Click [Process].
- Verify that the 'Max Length' value for field ' 'r_option_ids' is '16000'.
- Close the report and the form,
- Open [ReportA]
- Click to expand 'SYSTEM.RADplus_user_roles' table in the 'Field Explorer' section, to list all the fields and their associated field lengths shown next to each field
- Locate the 'r_option_ids' field
- Validate the associated field length value for the field is "16000"'
- Click to process the report
- Validate data is present in the 'r_option_ids' field, as expected
|
Topics
• NX
• SQL Data Access
• User Role Definition
|
