Re: os_authent_prefix

Thanks Stefan,

That cleared many things. But why sqlplus "ops$oracle/secret_at_testDb as sysdba" is not working? (ORA-01031: insufficient privileges).

Thanks

On 7/25/06, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
>
> if you're logged on locally, as oracle (the os_dba account) - and issue
> sqlplus yxz/abc as sysdba - or virtually anything/anything as sysdba oracle
> completely ignores whatever you enter for username / password and uses os
> authentication to authenticate you as sysdba.
>
> Stef
>
>
> On 7/25/06, Amir Gheibi <gheibia_at_gmail.com> wrote:
> >
> > Hello everyone,
> >
> > I use Oracle 10g R2 on Fedora Core 4, and I use password file.
> >
> > The value of "os_authent_prefix" is "ops$", (default) and the os user
> > that I'm able to login with it as sysdba using os authentication is named
> > "oracle". (connect "/ as sysdba")
> >
> > I've created a user in my database named ops$oracle with the code
> > bellow:
> >
> > create user ops$oracle identified by secret;
> > grant create session, dba to ops$oracle;
> >
> > I can connect as sysdba from a remote windows client like this:
> > sqlplus "ops$oracle/secret_at_testDb as sysdba"
> >
> > (testDb is the TNSNAME of that database in the tnsnames.ora file in
> > windows)
> >
> > but if I want to login to the database locally using the command bellow,
> > I get "ORA-01031: insufficient privileges" error:
> >
> > sqlplus "ops$oracle/secret_at_testDb as sysdba"
> >
> > As soon as I remove "@testDb" from the command, it works:
> >
> > sqlplus "ops$oracle/secret as sysdba".
> >
> > My underestanding is if I want to connect locally and I use tnsname in
> > the connection command, oracle will interpret it differently.
> >
> > Could anyone make this clear for me that why oracle acts differently,
> > please?
> >
> > Regards,
> > Amir
> >
> > PS: For God's sake do not ask why am I doing this?
> >
>
>

--
http://www.freelists.org/webpage/oracle-l