Re: OSLEVEL AUTHENTICATION

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Wed, 21 Dec 2005 20:04:44 -0500
Message-ID: <8pednfnNSMlEzzTeRVn-jg@comcast.com>

"Jo" <jacob.jomon_at_gmail.com> wrote in message news:1134625564.481035.258220_at_g49g2000cwa.googlegroups.com...
> Hi Experts,
> I am having a Question regarding the Os level
> Authentication.
> Scenario is
> I am having an OS level authenticted user in my
> database.User name : OPS$ORACLE.I am using the ORACLE 9.2.0.05 database
> on IBMAIX 5L server.Once I am in the unix login as oracle , I use to
> put a sqlplus / .At one point of time I was supposed to remove the os
> level authentication for the OPS$ORACL user. So I did an
> "alter user OPS$ORACLE identified by oracle";
> user alterd
> After that also if iam back in the Unix login as the oracle user and
> using a sqlplus /,it is allowing me with out asking password . can any
> one give some idea on this
>

If 'show user' or 'select user from dual', what is the result? My guess is that the 'oracle user' is part of some oracle_dba group Received on Wed Dec 21 2005 - 19:04:44 CST