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

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

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS
Post a Comment
Read more