Home > database >  User Created and granted privileges in sqlplus but from SqlDeveloper not connect
User Created and granted privileges in sqlplus but from SqlDeveloper not connect

Time:07-19

I have an Oracle 21c XE by Docker on Ubuntu 20.04. I created a user from the system and gave it to connect and resource privileges from sqlplus and I am able to connect from sqlplus but with the same credentials, I am not able to connect from SqlDeveloper. It's showing me an invalid username/password but I double-checked and the username and password are correct.

enter image description here

enter image description here

CodePudding user response:

You're trying to connect to the wrong database.

In SQL Developer you have

SID: XE

But in SQLPlus you are connecting to

Service: XEPDB1

So make your SQL Developer connection like this -

enter image description here

  • Related