My Oracle Support Banner

"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

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.