createOracle12cUser

In this bog, I will explain you how the user management work in oracle 12c. Starting from Oracle 12C there are two types of user. Common User Local User Common User Common user have the access to all PDB except seed pdb Common user start with C## prefix SYS and SYSTEM are the common user […]

We can create user in oracle 12c without c## but this is not recommended way. Oracle 12c has two kind of user called common user and local user. Still we can create oracle 12c user without c## by setting hidden parameter like below. SQL> select * from v$version; BANNER CON_ID ——————————————————————————– ———- Oracle Database 12c […]