Connect Oracle DB - How to enter credentials?

[MrBIn]

Hello,

I'm currently trying to connect to a on-prem Oracle Database.

Im 99,9% sure I have the right user credentials, but I'm unsure about how to enter them in the user name field.

I know that I have to add "as sysdba" somewhere, but entering it as below, Power BI returned an error message.

Am I missing something?

 

Thanks in advance.

[amitchandak · Accepted solution]

@MrBIn , why need to use as sysdba. You need to access table that you will get without using that

[MrBIn]

Nevermind, I used another DB user which is NOT "sys". Then I was able to access without "as sysdba". Thanks!

[MrBIn]

When I don't use "as sysdba", Power BI gives me the following error:

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