Connecting ORACLE as SYSDBA

  • Thread starter Thread starter Eidolon
  • Start date Start date
E

Eidolon

We currently use the Microsoft Native .NET Provider for Oracle to do our
connections with...
For one app we really need to be able to connect to the db as a SYSDBA user.

Does anyone know how this can be done using the MS.NET Oracle provider??

Thanks in advance,
 
I am not sure, as I am not as well versed on the admin side of Oracle. As
long as the SYSDBA user can be named or aliased (for a connection string), I
see no reason why not. I would be wary about where you store this
connstring, however; encryption would be a must for this type of secret.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Eidolon,

This was a much requested feature in the OLEDB MetaLink groups - and the
company line was always "not available now, but will consider it in future
releases" - and in OLEDB, it never came.

That said, Oracle did add it in the Oracle Data Provider for .Net. I have
no details on the Microsoft Native .NET Provider for Oracle, but here is how
we do it with the Oracle Provider:

/* ********************** */
string cnxtstr = "User Id=SYS;Password=ChangeOnInstall;DBA
Privilege=SYSDBA;Data Source=TNS_ENTRY;";
OracleConnection cnxn = new OracleConnection(cnxtstr);
cnxn.Open();
/* ********************** */


regards
roy fine
 
Eidolon,

This was a much requested feature in the OLEDB MetaLink groups - and the
company line was always "not available now, but will consider it in future
releases" - and in OLEDB, it never came.

That said, Oracle did add it in the Oracle Data Provider for .Net. I have
no details on the Microsoft Native .NET Provider for Oracle, but here is how
we do it with the Oracle Provider:

/* ********************** */
string cnxtstr = "User Id=SYS;Password=ChangeOnInstall;DBA
Privilege=SYSDBA;Data Source=TNS_ENTRY;";
OracleConnection cnxn = new OracleConnection(cnxtstr);
cnxn.Open();
/* ********************** */

regards
roy fine
 
Back
Top