Re: unique password for UNIX login AND oracle

In article <01bdc520$ece507e0$a07015a5_at_pc160>,   "simbl" <simblit_at_yahoo.com> wrote:
> Hi Gabriele,
>
> You can identify the user's password in Oracle as external.
>
> >alter user Gabriele identified externally;
>
> This identifies your Oracle login using the UNIX password, but this is
> controlled at the UNIX level and not inside the database. This might pose
> as a security issue, if that is a concern. Hope this helps.
>
> Cheers,
> Cynthia
>

Hi,

for this to work properly the username should have been created in the following way ( without taking account of tablespaces and quotas )

Create user OPS$Gabriele identified externally;

OPS$ is the prefix referenced by the OS_AUTHENT_PREFIX parameter, it might be something different on your system.

Regards

> podda <asmvo_at_asanet.it> wrote in article
> <01bdc213$ce139940$47150180_at_podda.ASM>...
> Is possible unique login Unix password with user Oracle password ?
> You have idea ?
>
> Thanks you,
> gabriele
>
>

--
Oliver Willandsen - European Commission http://europa.eu.int
All remarks are my own and do not necessarily coincide with official European Commission policy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 11 1998 - 09:41:22 CDT