Skip to Main Content

Oracle Database Express Edition (XE)

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!

Create user error

User_L3ELOJan 16 2022

-- I am in pdb
Do in SQL Developer and in sqlcli, the result the same:
-------------
CREATE USER "padmin" IDENTIFIED BY "padmin";
Error report -
ORA-65096: invalid common user or role name
65096. 00000 - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to the
usual rules for user and role names, common user and role names
must consist only of ASCII characters, and must contain the prefix
specified in common_user_prefix parameter.
*Action: Specify a valid common user or role name.
--------------
I see I do something wrong.
How to fix it?

This post has been answered by User_L3ELO on Jan 18 2022
Jump to Answer
Comments
Post Details
Added on Jan 16 2022
7 comments
3,875 views