Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

All numbers in Username

Merlin128Feb 14 2014 — edited Feb 15 2014

We have to change all of our usernames to 6 digit numbers..

I can create users in Oracle Database with all numbers.. I can log into Oracle Forms and BI with a username that is all digits..

But I know there will be problems... for example

connecting through a database link with all numbers as the userid will error with ORA-00987: missing or invalid username..

However, I can get around this by putting the username in quotes "000000" and then it works..

So my question is, are there any other problems I will run into?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2014
Added on Feb 14 2014
4 comments
1,249 views