Re: help: Bequeath?

Make the following setting in init.ora : os_authent_prefix = "ops$" <-- Can be anything, ops$ is the conventional setting

Bounce your database, create a user with a name ops$<unix-id> and :

	% id
	uid=1001(oracle) gid=101(dba)

	% sqlplus /

	SQL*Plus: Release 8.1.6.0.0 - Production on Fri Mar 22 17:42:15 2002

	(c) Copyright 1999 Oracle Corporation.  All rights reserved.


	Connected to:
	Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
	With the Partitioning option
	JServer Release 8.1.6.2.0 - Production

	DBAT > show user
	USER is "OPS$ORACLE"
	DBAT > 

But of course don't use the unix id oracle for something like this, this was just an example.

Shrieking in pain from a horribly disfigured body, "Winbatch" <winbatch_at_techie.com> groaned :

>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
>
>

===
Yurasis Dragon
spam_at_smeagol.com Received on Fri Mar 22 2002 - 18:57:10 CST