SUPPORT / SAMPLES & SAS NOTES
Usage Note 57446: Orphaned rows might occur in the APP_USER, APP_GROUP, and DATA_AUTHORIZATION tables
 |  |  |  |  |
In the SAS® Merchandise Intelligence Suite, there might be orphaned rows in the APP_USER, APP_GROUP, and DATA_AUTHORIZATION tables. The orphaned rows occur when you delete an account directly from the SAS® Management Console User Manager plug-in without first removing authorization for SAS Merchandise Intelligence for the account.
Follow the instructions to remove authorization for SAS Merchandise Intelligence in the Administrator's Guide for your particular solution before deleting the account from the User Manager plug-in to avoid this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Merchandise Intelligence | Microsoft® Windows® for x64 | ||
| 64-bit Enabled AIX | ||||