Login to oracle db using nodejs as sysdba

e7cdd8c5-e665-4ff9-aece-14656423a795

I am working on nodejs oracledb.I would want to login to oracle db from nodejs oracledb client asSYSDBA.Please suggest

Below is the snippet which am trying

<span class="pln" style="color: #000000;">oracleSYS3</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">getConnection</span><span class="pun" style="color: #000000;">({</span><span class="pln" style="color: #000000;"> user  </span><span class="pun" style="color: #000000;">:</span><span class="str" style="color: #800000;">"sys"</span><span class="pun" style="color: #000000;">,</span><span class="pln" style="color: #000000;"> password  </span><span class="pun" style="color: #000000;">:</span><span class="str" style="color: #800000;">"*******"</span><span class="pun" style="color: #000000;">,</span><span class="pln" style="color: #000000;"> connectString </span><span class="pun" style="color: #000000;">:</span><span class="str" style="color: #800000;">"connectionString"</span><span class="pun" style="color: #000000;">},</span><span class="kwd" style="color: #00008b;">function</span><span class="pun" style="color: #000000;">(){})</span><span class="pln" style="color: #000000;"> </span>

But I'm getting an error:

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

Christopher Jones-Oracle

Privileged connections are not supported yet.

To help us plan, what kind of operation are you trying to do and why are you doing it?

Christopher Jones-Oracle

Privileged connections are not supported yet.

To help us plan, what kind of operation are you trying to do and why are you doing it?

bidimensional

I was looking for the same, I would like to login as sysdba in order to be able to explore other schemas having the user inserting credentials only once.

Thanks,

bidi

Christopher Jones-Oracle

bidi, can you explain more? Are you planning to use ALTER SESSION?

bidimensional

Hi cj,

yes, but allso be able to perform operations with the schema prefix would be good for me (ie select * from schema.table)

Thanks,

bidi

Christopher Jones-Oracle

You can already use schema.table without needing SYSDBA.  Do you have a special case that needs SYSDBA?

More to the point, do you have any security concerns?  In PHP OCI8 you have to set a configuration file parameter as well as passing in an attribute to the connection call, which adds a level of protection since most people don't want SYSDBA privileges open on the web.