Re: Authentication of SYS

From: <xsun1913_at_my-dejanews.com>
Date: Tue, 20 Oct 1998 17:55:37 GMT
Message-ID: <70iiqp$vel$1@nnrp1.dejanews.com>

In article <70f6mp$jl8$1_at_nnrp1.dejanews.com>, fatman_at_pobox.com wrote:
> Ok, now I've created my first Oracle 7.3 database under NT.
>
> - I used oradim73, entered a DBA password there and then oradim told me
> that a password file has been created.
> - Then I changed REMOTE_LOGIN_PASSWORDFILE = exclusive in the parameter
> file.
> - Granted SYSDBA to SYS.
> - Shut down the instance.
> - Startup open.
> - connect as sysdba.
>
> Now Server Manager prompts for a username. If I enter SYS, I will be
> prompted for the SYS password. So far, ok. But I do not have to
> enter any password! Simply pressing ENTER will connect me as sysdba!
> How come??
>
> /Fatman
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

SYS already has both SYSDBA and SYSOPER privileges. you could try to grant SYSDBA to a user other than SYS, say scott, then log on as scott.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 12:55:37 CDT