OracleConnection

  • Thread starter Thread starter Grzybowski Rafa³
  • Start date Start date
G

Grzybowski Rafa³

Hi,

I'd like to ask You to solve my problem connecting to Oracle9.x database as
SYSDBA. How can I specify that 'AS SYSDBA' ? When I try to login with 'User
ID=SYS as SYSDBA' I always get Unknown user/password. Maybe I've placed my
problem wrong and should check Oracle permissions to do that ?

Thank You

Best regards
Rafa³ Grzybowski
 
I'd like to ask You to solve my problem connecting to Oracle9.x database as
SYSDBA. How can I specify that 'AS SYSDBA' ? When I try to login with 'User
ID=SYS as SYSDBA' I always get Unknown user/password. Maybe I've placed my
problem wrong and should check Oracle permissions to do that ?
Click to expand...

It is my understanding that you can not connect as sysdba with ADO/OleDB
(I'm sure someone will jump in here and correct me if I'm wrong).
The closest thing I'm aware of you can do is create a useraccount
that has all (most) of the same priviledges as sysdba and connect using
that account.

hope this helps,

Doug.
 
It is my understanding that you can not connect as sysdba with ADO/OleDB
(I'm sure someone will jump in here and correct me if I'm wrong).
Click to expand...
No, I'm using Microsoft .NET Data Provider for Oracle. And I really want to
connect using existing account SYS.
I need to now is it possible or not, and where my error is?
 
Hi Rafal,
as I know it is only possible with Oracle .NET managed provider.

Best regards

Ryszard Gawron
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Ryszard Gawron said:
Hi Rafal,
as I know it is only possible with Oracle .NET managed provider.

Best regards

Ryszard Gawron
Microsoft Developer Support
Click to expand...

I use .NET managed Oracle provider and stil don't know how ?
Please give me any advice
 
Hi Rafal,
sorry I was not precise enough. I mean ODP managed provider from Oracle and
not from Microsoft. In the documentation you can find following:
// C#

..

OracleConnection con = new OracleConnection();

con.ConnectionString = "User Id=SYS;Password=SYS;" +

"DBA Privilege=SYSDBA;Data Source=oracle;";

con.Open();

Best regards

Ryszard Gawron
Microsoft Developer Support
 
Only the provider from Oracle supports this, and in any case in general you
should not be using sysdba from code. What is the operation you wish to
perform. SYSDBA essentially gives you permission to start/stop the Oracle
server and perform INCOMPLETE recovery i.e serious DBA tasks. No DBA worth
their salt would be doing this sort of thing with a third party tool.
 
Back
Top