Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 12c users create     - Based on a complete solution RMI service to transfer large files (Programming)

- The basic principle of pointers in C ++ (Programming)

- The mv command to move the directory two cases under Linux (Linux)

- How to update the ISPConfig 3 SSL Certificates (Server)

- To convert into a binary search tree sorted doubly linked list (Programming)

- Arrow keys, backspace key garbled in Python-2.7.5 Interactive Mode under CentOS 5.8 (Linux)

- Django how to generate content in non-HTML formats (Programming)

- Zabbix configure DataGuard monitoring (Database)

- How to use Xmanager Remote Desktop and VNC Log (Linux)

- Linux find command usage practices (Linux)

- Java threads and thread pools (Programming)

- Fedora 8 configured Heartbeat (Linux)

- Production Environment MongoDB Fragmentation and Cluster Solution (Database)

- Ubuntu 15.04 installation Powercommands 2.0 (Linux)

- Three strategies to teach you to release the device memory (Linux)

- The difference Docker save and export commands (Linux)

- Linux file system management partition, format, mount - label mount (Linux)

- ElasticSearch basic usage and cluster structures (Server)

- Ubuntu 14.04 How to set up an SSH without password (Linux)

- Postfix mail service system principle and configuration (Linux)

 
         
  Oracle 12c users create
     
  Add Date : 2018-11-21      
         
       
         
  Oracle 12c can be divided into public accounts and local user accounts, there are accounts created in the CDB, the PDB can give all users, local accounts are accounts that can be created in the PDB

Create a common user
 alter session set container = CDB $ ROOT;
create USER C ## u02 identified by oracle container = all;
Create a local user
 alter session set container = pdb4;
create USER u01 identified by oracle container = current;

SQL> SELECT USERNAME, CON_ID, USER_ID FROM CDB_USERS WHERE USERNAME = 'U01';
USERNAME CON_ID USER_ID
------------------------------ ---------- ----------
U01 4 105

Create a test account in the CDB
1 Create an account must begin with C ## in the CDB
 alter session set container = CDB $ ROOT;
SQL> create user orcl identified by a;
create user orcl identified by a
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> create user p ## orcl identified by a;
create user p ## orcl identified by a
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> create user c ## a identified by a;
User created.


SQL> select username from dba_users where username like 'C ##%';
USERNAME
-------------------------------------------------- ------------------------------
C ## A

--- Description Local users can not begin with C ##
 alter session set container = pdb4;
SQL> create user c ## B identified by B;
 create user c ## B identified by B
            *
ERROR at line 1:
ORA-65094: invalid local user or role name

SQL> SELECT USERNAME, CON_ID, USER_ID FROM CDB_USERS WHERE USERNAME like 'C ##%' ORDER BY USERNAME;
USERNAME CON_ID USER_ID
------------------------------ ---------- ----------
C ## BOSWLL 4 103
C ## BOSWLL 3 110
C ## BOSWLL 1 102
C ## BOSWLL 5 103
C ## U02 4 106
C ## U02 5 104
C ## U02 1 103
C ## U02 3 111

 When --- create public users can not create pdb, you must create a public user in the cdb
 SQL> alter session set container = pdb4;
Session altered.

SQL> create USER C ## u02 identified by oracle container = all;
create USER C ## u02 identified by oracle container = all
                                *
ERROR at line 1:

ORA-65050: Common DDLs only allowed in CDB $ ROOT

to sum up:
1 public users must, local users start with a letter, the user can not begin only in the beginning of the C ## to C ##
2 Create a public user, must be in the CDB $ ROOT
3 If there is already a user or role in the PDB, in the CDB can not create the same account name or role
     
         
       
         
  More:      
 
- How to Install Telegram instant messaging software on Ubuntu (Linux)
- Go constructed using an interpreted language (Programming)
- PL / SQL how to make the program every few seconds to insert a data (Database)
- CentOS 7 virt-manager can not connect a local hypervisor (Linux)
- Linux environment variable settings methods and differences (Linux)
- Linux platform Oracle MySQL connection (Database)
- How Bluetooth turned off by default in Ubuntu 14.04 (Linux)
- Bubble Sort Algorithms (Programming)
- Installation of Theano + CUDA under Ubuntu (Linux)
- Scope of variables in Object-C (Programming)
- Linux command to view the system status (Linux)
- CentOS Nginx achieve 3 virtual machine load balancing (Server)
- Make full use of the Raspberry Pi SD card space (Linux)
- How to ensure the Linux SSH login security with one-time password (Linux)
- Spring WebSocket Comments (Programming)
- grub boot error resolution examples (Linux)
- CentOS 7 Docker build private warehouse registry (Linux)
- Oracle 11g logical standby achieve BI needs (Database)
- CentOS NAT iptables (Linux)
- Spring AOP custom annotation way to achieve log management (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.