SysDba privilege is restricted to Sys Y?

SysDba privilege is restricted to Sys Y?

Postby 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
SAK
 
Posts: 1
Joined: Mon 03 Oct 2005 07:16
Location: Pakistan

Postby 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
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle