PDB下建的用户只能以sysdba登录
我alter PLUGGABLE database XX open;打开了PDB，并 alter session set container＝XX登录到了PDB。但是我创建下的 用户后貌似只能用sysdba登录 这是怎么回事啊
oracle12c的pdb用户权限是隔绝的，只有root下的用户可以连接到各个pdb，前提得赋予权限
SQL> create user c##test identified by aa;
User created.
SQL> create user c##test1 identified by aa;
User created.
SQL> grant connect to c##test
2;
Grant succeeded.
SQL> grant connect to c##test1
2;
Grant succeeded.
SQL> show pdbs
CON_ID CON_NAME OPEN MODERESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLYNO
3 PDB1 READ WRITE NO
4 PDB2 MOUNTED
SQL>
SQL> conn c##test/aa
Connected.
SQL> show user
USER is "C##TEST"
SQL> alter session set container=pdb1;
ERROR:
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL>grant connect to c##test container=all;
Grant succeeded.
SQL> conn c##test/aa
Connected.
SQL> alter session set container=pdb1;
Session altered.
SQL> show users
SP2-0158: unknown SHOW option "users"
SQL> show user
USER is "C##TEST"
SQL> conn system/oracle@pdb1
Connected.
USERNAME INST_NAME HOST_NAME SID SERIAL#VERSION STARTEDSPID OPIDCPID SADDR PADDR
-------------------- ------------ ------------------------- ----- -------- ---------- -------- --------------- ----- --------------- ---------------- ----------------
SYSTEM orcl localhost.localdomain 49 139 12.1.0.1.0 20140501 4559 36 4456 000000009F721CE8 000000009FA5E368
SQL> grant connect to c##test1;
Grant succeeded.
SQL> conn c##test1/aa
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container=pdb1;
Session altered.
12C都用上了吗
生产库有用吗 T总威武 http://www.xifenfei.com/4432.html 可以参考这篇文章
页:
[1]