Connecting ORACLE as SYSDBA

Eidolon

unread,

Mar 15, 2004, 9:11:35 AM3/15/04

to

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,

Cowboy (Gregory A. Beamer)

unread,

Mar 15, 2004, 10:21:44 AM3/15/04

to

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" <eidoloni...@yahoo.com> wrote in message
news:eCSZudpC...@tk2msftngp13.phx.gbl...

Roy Fine

unread,

Mar 15, 2004, 8:21:28 PM3/15/04

to

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" <eidoloni...@yahoo.com> wrote in message
news:eCSZudpC...@tk2msftngp13.phx.gbl...

Roy Fine

unread,

Mar 15, 2004, 8:23:33 PM3/15/04

to

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" <eidoloni...@yahoo.com> wrote in message
news:eCSZudpC...@tk2msftngp13.phx.gbl...