Skip to main content

RADplus 2023 Update 26

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

RADplus required

Product Update Form Description

An issue where two Users whose User IDs differed only by the placement of periods would receive incorrect SQL table permissions is resolved going forward.

Included Updates

12

Required Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
SQL table permissions
An issue is resolved to ensure that respective SQL table permissions are assigned, in the case where two users have the same User ID's that differ only by the placement of periods within their User ID's
Topics
• SQL Data Access
 
Acceptance Tests
AV-86455 Summary | Details
SQL table permissions
Scenario 1: User Definition - Validate a user's SQL "ODBC" Table permissions
Specific Setup:
  1. Two users exist on the system that have the same "User ID", but which differ by where the period within their user ID is placed. For this example: "U.serA" and "User.A"
  2. "U.serA" has access to the "SYSTEM.patient_current_demographics" table
  3. "U.serA" does not have access "SYSTEM.Admission_data" and "SYSTEM.Appoinment_data" table
  4. "User.A" also has access to "SYSTEM.patient_current_demographics" table
  5. "User.A" does have access to the "SYSTEM.Admission_data" and "SYSTEM.Appiontment_data" tables'
  6. Each user has access to 'Crystal Reports" or other database program to make an ODBC connection and view their assigned SQL Table
Steps
  1. Open the database program, for this example "Crystal Reports" is used
  2. Click "File" on the menu and then "New" to create a new report
  3. At the "Data" dialog, click "Create New Connection"
  4. Double-click "ODBC"
  5. From the "Data Source Selection" dialog, locate the data source name created for user ID "U.serA" and double-click to select it
  6. Populate the "User ID" field and "Password" with the credentials for "U.serA"
  7. Click "Finish"
  8. At the table tree list
  9. Click the "SYSTEM" schema folder and then click "Tables"
  10. Validate the "SYSTEM.patient_current_demographics' table is present in the list
  11. Validate the "SYSTEM.Admission_data" and "SYSTEM.Apppintmentt_data" tables are "not" present, as expected
  12. Click 'Cancel"
  13. Click "File" on the menu and then "New" to create a new report
  14. At the "Data" dialog, click "Create New Connection"
  15. Double-click "ODBC"
  16. From the "Data Source Selection" dialog, locate the data source name created for user ID "User.A"
  17. Populate the "User ID" field and "Password" with the credentials for "User.A"
  18. Click "Finish"
  19. At the table tree list
  20. At the table tree list
  21. Click the "SYSTEM" schema folder and then click "Tables"
  22. Validate the "SYSTEM.patient_current_demographics' table is present in the list
  23. Validate the "SYSTEM.Admission_data" and "SYSTEM.Appointment_data" tables "are" present, as expected
Topics
• SQL Data Access

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Page type
    Reference
  2. Tags
    1. content:release
    2. llm-no-index
    3. role:sysadmin
    4. search:ready
    5. SQL Data Access