3075729 - Technical Database Users Are Not Removed When Company Schema is Deleted

Symptom

The B1_<hash>_RW user created by the System Landscape directory (SLD) for the company schema remains in the system when the company schema is deleted.

Reproducing the issue

You are using version 10.0 of SAP Business One.

Scenario:

• Select a company schema in the SLD.
• This schema has in SLD --> Companies --> Database User column assigned a company specific database user : B1_53424F44454D4F4341_RW (for example).
• Drop the schema from SAP HANA Database Studio using "Cascade" option or delete the schema from Microsoft SQL Server Management Studio.

Expected behavior:

Company specific database user is removed when the schema is dropped.

Actual behavior:

Company specific database user B1_53424F44454D4F4341_RW (for example) is still present in the list of database users.

Cause

System Limitation

Solution

This is a system limitation.

Workaround:

Delete the obsolete technical database users manually.