如何在oracle 12c中建立普通使用者

標籤：

-------如何在oracle 12c中建立普通使用者-------
[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 21:43:50 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

--通過con_name能看到當前登入的環境是CDB根庫,CDB包含一個名為PDBORCL的可插拔庫。
SQL> show con_name pdbs;

CON_NAME
------------------------------
CDB$ROOT

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBORCL MOUNTED

--建立公用使用者admin，需要使用C##或者c##作為該使用者名稱的開頭。
SQL> create user C##admin identified by Lxf$txx282534;

User created.

--如果使用普通方法建立會報錯
SQL> create user admin identified by Lxf$txx282534;
create user admin identified by Lxf$txx282534
*
ERROR at line 1:
ORA-65096: invalid common user or role name

--建立公用角色， 同公用使用者一樣也需要使用C##或者c##作為角色名稱的開頭。
SQL> create role C##admin01 container=all;

Role created.

--將dba角色授予公用角色, 適用範圍為所有PDB
SQL> grant dba to c##admin01 container=all;

Grant succeeded.

--將公用角色授予公用使用者， 使用範圍為所有PDB
SQL> grant C##admin01 to C##admin container=all;

Grant succeeded.

--下面使用公用使用者分別登入CDB、PDB看看是否通用。
[[email protected] admin]$ sqlplus C##admin/‘Lxf$txx282534‘@pdborcl

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:33:29 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Sun Nov 29 2015 22:31:12 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name;

CON_NAME
------------------------------
PDBORCL


[[email protected] admin]$ sqlplus C##admin/‘Lxf$txx282534‘

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:33:53 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Sun Nov 29 2015 22:33:29 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT

在PDB中建立使用者和建立普通使用者就沒有什麼區別了
SQL> create user test identified by test;

User created.
SQL> grant create session to test;

Grant succeeded.
[[email protected] admin]$ sqlplus test/[email protected]

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:17:16 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show user
USER is "TEST"
SQL> show con_name

CON_NAME
------------------------------
PDBORCL
SQL> exit

--將PDB開啟
SQL> alter pluggable database pdborcl open;
Pluggable database altered.

--切換到PDB容器
SQL> alter session set container=pdborcl;
Session altered.

如何在oracle 12c中建立普通使用者