CODEWITHSUNDEEP
oracle-databaseoracle-apexoracle12coracle-apex-19.1
Ramiz Tariq
Ramiz Tariq

Reputation: 387

How to connect apex user with oracle sqldeveloper

I create new user in Apex 19. I want to connect apex user with oracle sqldeveloper. I have oracle database 12c and Apex 19 Installed.

Anyone know how to connect?

Thanks

Upvotes: 1

Views: 3948

Answers (2)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

You can't connect to an APEX user via SQL Developer. You need to use/create a database schema account.

You can create database accounts by first connecting to your database using a DBA account (e.g. SYSTEM or SYS). Alternatively, if your APEX workspace was created using the defaults it may have created a database schema account as well, so if you know its password you may be able to connect to it via SQL Developer as well.

Upvotes: 1

Littlefoot
Littlefoot

Reputation: 143063

Connect as you connect to any other user - provide its username and password.

  • Apex is installed into the database (it is yet another user in there)
  • I presume you created a new database user via Apex, while mapping workspace to a database schema
    • if you chose "New", Apex created a new database user for you - that's the one you want to connect to, right?
  • as you know its username (you set it) as well as its password, use those credentials in SQL Developer

Upvotes: 0

Related Questions