Thanks a lot. I'll try it out. (Thanks for the examples as well).
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:a7elqn$i5i$1_at_lust.ihug.co.nz...
> No it's not called bequeath (that's what happens when the Listener spawns
> you a Server Process instead of redirecting you to a pre-spawned one).
What
> you want is 'O/S authentication of ordinary users' (as opposed
> to O/S authentication of privileged Users, which uses an entirely
different
> mechanism).
>
> You need to create user ops$blah identified externally, then grant the
> relevant privileges.
>
> Then you should adjust the init.ora parameter REMOTE_OS_AUTHENT and set it
> to true. One Instance boucen later, and all should be well:
>
> SQL> connect system/manager_at_db9
> Connected.
> SQL> create user ops$howardjr identified externally;
>
> User created.
>
> SQL> grant dba to ops$howardjr;
>
> Grant succeeded.
>
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.0.1.1.1 -
Production
> With the Partitioning option
> JServer Release 9.0.1.1.1 - Production
>
> C:\Documents and Settings\howardjr>sqlplus "/ @db9"
>
> SQL*Plus: Release 9.0.1.0.1 - Production on Fri Mar 22 18:09:36 2002
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01004: default username feature not supported; logon denied
>
> ================================================
> (At this point, I go to the server and set REMOTE_OS_AUTHENT=TRUE, and
bouce
> the Instance)
> ================================================
>
> C:\Documents and Settings\howardjr>sqlplus "/ @db9"
>
> SQL*Plus: Release 9.0.1.0.1 - Production on Fri Mar 22 18:14:29 2002
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
> With the Partitioning option
> JServer Release 9.0.1.1.1 - Production
>
> SQL> show user
> USER is "OPS$HOWARDJR"
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Winbatch" <winbatch_at_techie.com> wrote in message
> news:a7ed5e$rpk$1_at_bob.news.rcn.net...
> > Hi,
> > I need some help. I have been asked to modify our 8.1.6 oracle
> installation
> > on solaris machine so that clients can connect based on unix username.
I
> > think this is called bequeath? I did some poking/asking around and I
> > created a username called OPS$woba where woba is the name of the unix
user
> I
> > want to use. I was told all I needed to do was create the user, grant
it
> > select and resource rights and that the user would be able to do sqlplus
> > without any parameters: sqlplus /
> >
> > Unfortunately, this is not working. I think because I think I need to
do
> > something special on the server side to set this up. Could someone
point
> me
> > in the right direction? Do I need to add a special listener of some
sort?
> >
> > Thanks
> > Winbatch
> >
> >
> >
>
>
Received on Fri Mar 22 2002 - 05:48:43 CST
