Forum Stats

  • 3,852,824 Users
  • 2,264,140 Discussions
  • 7,905,154 Comments

Discussions

Create a new user on PDB on Oracle XE

user1045523
user1045523 Member Posts: 2 Green Ribbon

Good afternoon.   I'm having some trouble to create a user in XE pdb. 

  After I log in to sqlplus using sysdba I type :

  alter session set containner = xepdb1 ;

  CREATE USER Tarlensus IDENTIFIED BY ****** DEFAULT TABLESPACE tbs_Tarlensus TEMPORARY TABLESPACE temp QUOTA 15M ON tbs_Tarlensus; 

  Done this I give a grant to thi user :

  GRANT CREATE SESSION to Tarlensus ; 

  But when I will login using sqlplus :

[email protected] the Oracle DB returns that user or password are invalid. 

  Where am I going wrong? 

  I am using environment  Oracle Linux Environment and Oracle XE 21.c

Best Answer

Answers