Re: Bequeath?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 22 Mar 2002 18:16:54 +1100
Message-ID: <a7elqn$i5i$1@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

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

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 - 01:16:54 CST