Unregistering OWB 11.2 User After it Was Dropped and Recreated on Database Level Fails With ORA-20007: WORK_USER is not a registered user of this workspace.
(Doc ID 2056910.1)
Last updated on JULY 03, 2018
Applies to:Oracle Warehouse Builder - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
You are unable to register/unregister user in OWB 11.2.
ORA-20024: The user with name:WORK_USER has already registered to the workspace <name>
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1270
ORA-06512: at line 1
Attempt to drop OWB user failed with error:
Attempt to re-register the same user fails with error:
Attempt to re-register the same user after having tried to unregister fails with error:
SQL> exec owbsys.wb_workspace_management.REGISTER_WORKSPACE_USER('WORK_USER');
BEGIN owbsys.wb_workspace_management.REGISTER_WORKSPACE_USER('WORK_USER'); END;
ERROR at line 1:
ORA-20003: WBSecurityHelper found the SQL error:ORA-20007: WORK_USER is not a registered user of this workspace.
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1366
Database user was dropped without being unregistered in OWB before and then recreated with the same name.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document