ssarkar_at_orion-gis.com (Satinath Sarkar) wrote in message news:<a722f987.0402021925.33f33707_at_posting.google.com>...
> I have an unusual need and any help would be appreciated. I am running
> Oracle 9.2.0.1 on Windows XP pro. I have O/S authentication configured
> and working fine. When I login as SQLPLUS / everything works fine. Is
> there anyway I can provide a username and password on the prompt and
> still login to oracle as the current OSUSER. For example if the logged
> in user is FRED and Oracle user is OPS$FRED IDENTIFIED extrnally and I
> am logged into Windows XP as FRED. Can I type SQLPLUS
> somejunkusername/somejunkpassword and still login to ORACLE as
> OPS$FRED.
If you enter somejunkusername/somejunkpassword, then you won't be
able to login as ops$fred.
If you CREATE USER OPS$FRED IDENTIFIED BY APASSWORD, instead of
'externally', then you can login with ops$fred/apassword, or
with just /
--
Joe
http://www.cafeshops.com/joekaz
http://www.joekaz.net
Received on Tue Feb 03 2004 - 07:05:19 CST
