Re: internal accepts any password

OK, that all makes sense now, though Internal currently won't except a null password.

Looks like I need to use ORAPWD to create a password file for SYS and INTERNAL.

Is there a source of info that explains ORAPWD in greater detail than the Oracle 8i DBA Handbook? There's a few things that are still unclear about ORAPWD and I don't wnat to go mucking with my live database until I'm sure of all the consequences.

Thx,
D.

Sean M <smckeownNO_at_BACKSIESearthlink.net> wrote:
>
>dsmcd wrote:
>>
>> Using DBA Studio or SQLPlus Worksheet at the server, I can
>> connect as internal using any password. Any combination of
>> keystrokes will do. It's a rather disturbing thing to watch.
>> Using the same tools on client stations requires the proper
>> password.
>
>Sounds like you have your db setup for OS authentication,
>meaning you
>needn't provide any password at all when connecting internal.
>Oracle
>isn't checking the password against a password file, it's only
>checking
>which OS group/privs you have. So any password (or none) will
>do, as
>long as you're on the db server host with the right privs (or a
>client
>machine with a secure connection, if that's configured).
>
>Regards,
>Sean
Received on Mon Apr 15 2002 - 11:50:32 CDT