"ORA-20002: WBSecurityHelper found the SQL error:ORA-01935: missing user or role name" At User Registration or Creation in OWB 11.1

(Doc ID 985953.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

***Checked for relevance on 21-Jan-2013***

Symptoms

Registration or Creation of an oracle Warehouse Builder User having its name starting with a numeric value fails with the following error :

ORA-20002: WBSecurityHelper found the SQL error:ORA-01935: missing user or role name



Scenario
=======
  1. Start OWB Design Center and connect.
  2. Go Global Explorer panel.
  3. Expand the Security -> User tree.
  4. Right click on user then choose NEW.
  5. Select a username like 123456  or click on Create DB User button then write the new user name with numeric value such as 123456 then press OK
  6. The error will be raised

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms