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.
How to solve user creation problem in Oracle 12C DBMS?
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 !!!
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
But now in Oracle 12C has some changes. Shown in Figure 01.
 |
| Figure-01: Invalid common user or role name |
How to solve user creation problem in Oracle 12C DBMS?
 | ||||||
| Figure-02: Create user in Oracle 12C database |
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 !!!
Comments
Post a Comment