Re: unique password for UNIX login AND oracle

Peter Ziobrzynski <pzi_at_pzi.net> writes:

> oliver.willandsen_at_sg.cec.be wrote:

<snip>
> Do you know in which Oracle version UNIX authentication was implemented first.
> I have 7.2.3 and create users as above and sqlplus still prompts for password
> and fails:
>
> SQL> create user ops$pzi identified externally;
> SQL> grant create session to ops$pzi;
> SQL> select name,value from v$parameter where name = 'os_authent_prefix';
> ops$
> SQL> quit
> % sqlplus
> Enter user-name: pzi
> Enter password:
> ERROR: ORA-01017: invalid username/password; logon denied
> Enter user-name: ops$pzi
> Enter password:
> ERROR: ORA-01017: invalid username/password; logon denied
>

<snip>
External authentication through Unix has been around since at least Version 6. Check the value of the init.ora parameter OS_AUTHENT_PREFIX. It may be set to some value different than "OPS$".
--

                                        Rick
                                        Rick Wessman
                                        Distributed Data Security
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com