Skip to main content

Invalid common user or role name

Use the CREATE USER statement to create and configure a database user, which is an account through which you can log in to the database, and to establish the means by which Oracle Database permits access by the user.



In Oracle 12C database has major change in software architecture. That's why user creation has some changes.In previous release of Oracle you can create user using

CREATE USER  > IDENTIFIED BY <password>.

But now in Oracle 12C  has some changes. Shown in Figure 01.
invalid-common-user-role-name
Figure-01: Invalid common user or role name














How to solve user creation problem in Oracle 12C DBMS?

user-create-oracle12C-database
Figure-02: Create user in Oracle 12C database





Look at Figure-02.

The following example shown in Figure:-02 creates a common user called c##uerp in a CDB.








Ref: Oracle® Database SQL Language Reference 12c Release 1 (12.1)

-- Cheers !!!
Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.
Post a Comment
Read more

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System).   Basically Its’s occurring on windows platform.
Post a Comment
Read more

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???
Post a Comment
Read more