Re: unique password for UNIX login AND oracle

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: Fri, 14 Aug 1998 11:03:16 GMT
Message-ID: <ExoEpH.Gsr@liverpool.ac.uk>

rwessman_at_us.oracle.com wrote:
: 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

At the Enter user-name prompt reply / rather than pzi or just simply type sqlplus /

Helen Received on Fri Aug 14 1998 - 06:03:16 CDT