Home » RDBMS Server » Server Administration » Login into database without correct password in SYS user
Login into database without correct password in SYS user [message #166572] Fri, 07 April 2006 00:54 Go to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
I've installed oracle 9i in my local m/c. For SYS & SYSTEM users I'm able to login into the DB using any incorrect password ( Null password is not allows me to login), but for regular users say for Scott, if i give incorrect password, I'm not allowed to login. Why this happens to SYS & SYSTEM users alone & how to overcome this ?
Clarify my doubts!!!

Thanks in advance,ponnilavan

Report message to a moderator

Re: Login into database without correct password in SYS user [message #166575 is a reply to message #166572] Fri, 07 April 2006 01:05 Go to previous messageGo to next message
raddisonlee
Messages: 29
Registered: March 2005
Junior Member
is it logon with
conn / as sysdba ? on server side?

Report message to a moderator

Re: Login into database without correct password in SYS user [message #169320 is a reply to message #166572] Wed, 26 April 2006 04:52 Go to previous message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
Oracle is installed in my home PC & I'm giving the below in Windows command prompt

cmd > sqlplus

user name : sys
password : xxxx as sysdba


Thanks in advance,
Ponnilavan

Report message to a moderator

Previous Topic: Database Migration (8i to 10g)
Next Topic: If a user complaints the database is slow
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:37:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.