oracle-databaseoracle-sqldeveloper

How to connect as admin in an existing connection in SQL Developer


I downloaded the Oracle DB Developer VM a while back and successfully created a new connection to connect to this VM in my SQLDeveloper app. Currently this connection only has HR schema and I would like to install another Oracle schema from this Github link to the existing connection.

As you can see in the README.md file (from the provided link) it says that I need to connect as privileged user with rights to create another user (SYSTEM, ADMIN, etc.).

How do I connect to the existing connection containing the HR schema as an admin/system user to run the sql files? I am logged in as 'HR' user in the existing connection and thus - as expected - I got ORA-01031 insufficient privileges error when I tried to run any of the sql files in the SQLDeveloper app.


Solution

  • I am finally able to login as sys (please set the role = SYSDBA) in Sql Developer by creating a new connection - thanks to MTO for the tip!