Re: 9.2.0.1.0 sys login question

Hi!

Oracle checks that you are in "dba" group and lets you in. When you installed the software, you were asked for the sysdba and sysoper group name and when executables were linked, this information was stored in the executable.

Try to log on under another local user who doesn't have "dba" group (or whatever group name you specified during install).

In Windows you have to be a member of ORA_DBA or ORA_<sid>_DBA group to get same kind of behaviour.

Tanel.

"RR" <rickraster_at_hotmail.com> wrote in message news:97b4acf3.0307220815.50d2b393_at_posting.google.com...
> From the server (linux) commandline, I sparked up sqlplus, and typed
> in sys at the username prompt. I typo'd the login slightly by entering
> "as sysdba" as the sys password, and not the actual sys password, and
> hit enter. This logged me in as the sys user.
>
> My question then is this: is this normal behaviour?
> It's the first time I've noticed this, so my only assumption is that
> this is a product of OS authentication or something. Rather alarming
> if this happens to others as well.
> I tried the same process from a remote sqlplus session, but couldn't
> get in. SSH'ing into that server, and using sqlplus, also allowed me
> in (which makes sense given the way ssh works).
>
> Anyone able to shed any light on this?
>
> Cheers,
>
> Rick
Received on Tue Jul 22 2003 - 12:33:06 CDT