Forum Discussion

MrBIn's avatar
MrBIn
Frequent Visitor
4 years ago
Solved

Connect Oracle DB - How to enter credentials?

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.

Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

    • MrBIn's avatar
      MrBIn
      Frequent Visitor
      4 years ago

      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

    • MrBIn's avatar
      MrBIn
      Frequent Visitor
      4 years ago

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