Re: hide password for client sessions

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 12 Mar 2004 22:52:30 +1100
Message-ID: <4051a485$0$3956$afc38c87@news.optusnet.com.au>

"John Leslie" <johnleslie_at_madasafish.com> wrote in message news:4412dd31.0403120110.63bd27b9_at_posting.google.com...
> For security reasons I do not want my users to specify a password to
> an oracle user when starting an application on their PC. The
> application connects using Oracle 9.2 client. Can I default the
> password somewhere...in the sqlnet.ora file or somewhere?
>
> N.B. using OS authentication is not an oprion.

Why? O/S authentication is, of course, nothing of the sort. O/S authentication for ordinary users (create user fred identified externally) ultimately ends up being data dictionary authentication, with Oracle merely confirming that the O/S user has an entry in the data dictionary.

It requires no O/S setup, if that was your concern, unlike the true O/S authentication that exists for privileged users (connect / as sysdba), which requires O/S groups and memberships of said groups to be set up correctly.

Regards
HJR Received on Fri Mar 12 2004 - 05:52:30 CST