SysDba privilege is restricted to Sys Y?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
SAK
Posts: 1
Joined: Mon 03 Oct 2005 07:16
Location: Pakistan

SysDba privilege is restricted to Sys Y?

Post by SAK » Mon 03 Oct 2005 07:20

Hi,
I am using oradirect 3.1.2.0 professional. I am encountering a problem when I am trying to connect as SysDba. I am using the following connection string:
ConnectionString= "Direct=True;Server=IP;Port=Port;Sid=SID;Password=manager;User Id=System;Connect Mode=SysDba;
It’s not connecting to the server and gives error:
ORA- 01017 : invalid username/password; logon denied
While everthing is right.When I tries to connect with userid=sys and password=syspassword it creates connection with the server, I would like to know that why other users are not allowed to connect with privileges other than Default, it seems that connect mode option is useful only for sys user what if other users want to connect as SysDba???
Regards
SAK

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 04 Oct 2005 06:54

"SYSTEM" user is not SysDba by default. You must execute

GRANT SYSDBA TO YourUserName;

to allow connecting as SysDba. Please test your account with SQL*Plus

Post Reply