DataGrip: how to connect to Oracle as SYSDBA

Question

I tried to setup in DataGrip an Oracle connection under SYS user.

But got error:

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

But there is no option in GUI to choose as SYSDBA option.

Answer 1

Coming back here two years later, it seems to be not possible anymore to change the advanced properties in the connection settings.

Instead you have to supply sys as sysdba as username. (This might seem obvious but took me a while to find this out)

Answer 2

While there is no easy switch currently, it's still possible to go to Advanced tab in connection's properties and set internal_logon param to sysdba value.

Answer 3

sys as sysdba as username works fine for Database plugin in IntelliJ IDEA.