Hi,
-> I have an Oracle RDBMS 12c.
-> I have a set f containers:
Container Totaal
name Container Container Open Open size Recovery
(PDB) ID DBID UID mode Restrict time (MB) status
--------------- ---------- ------------- ------------- ------------ -------- ------------------- ---------------- ----------
CDB$ROOT 1 3129040689 1 READ WRITE NO 2015/09/27:09:18;06 0 ENABLED
PDB$SEED 2 550179998 550179998 READ ONLY NO 2015/09/27:09:18;06 1,010 ENABLED
FREYA 3 1738182686 1738182686 READ WRITE YES 2015/09/27:09:19;41 2,496 ENABLED
ODIN 4 4236311420 4236311420 READ WRITE YES 2015/09/27:09:19;41 1,050 ENABLED
LOKKI 5 3332235708 3332235708 READ WRITE YES 2015/09/27:09:19;41 1,050 ENABLED
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
create user c##admin identified by "motezuma"
default tablespace USERS
quota unlimited on USERS
container=all;
grant create session to c##admin;
SQL> select username from dba_users where upper(username) like 'C##%';
USERNAME
--------------------------------------------------------------------------------
C##ADMIN
SQL> select PRIVILEGE from cdb_sys_privs where GRANTEE = 'C##ADMIN';
PRIVILEGE
----------------------------------------
CREATE SESSION
-> Now I connect as SYS to the PDB:
[oracle@oel6564-odb12c-s1 ~]$ sqlplus sys@LOKKI as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Sep 27 11:42:27 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
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
------------------------------
LOKKI
SQL> connect C##ADMIN@LOKKI
Enter password:
ERROR:
ORA-01045: user C##ADMIN lacks CREATE SESSION privilege; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
Does someone faced this situation?
Thanks by advance for any tip.
Kind Regards