Re: Users identified by passwd may also be identified externally

Alain.Viret_at_ls.ubs.ubs.ch (Alain VIRET) writes:
:
: With Oracle 7.0.15.4 (Solaris 2.3), when we define an user with the command:
: create user toto identified by titi
: If an Unix toto exist, it may execute sqlplus / and enters in the
: database.
:
: With another instance and version (7.0.16.x), with the same command
: of the user's creation, the user Unix toto may not enters in the
: database without giving its password (titi in the example).
:
:
: Is it a bug or a known feature or a different parameter ?

Most likely NOT a bug. Sounds like an OS authenticated account. This is the same as OPS$ accounts in v6, however, in Oracle7, you are allowed to change the OPS$ to any string you like. This is done via the OS_AUTHENT_PREFIX in the INIT.ORA(the default value for this is still OPS$)

If, for example, you have an OS account X, a Oracle account ZZZX, and OS_AUTHENT_PREFIX=ZZZ, then user X would connect to Oracle account ZZZX byt typing sqlplus / Received on Wed Oct 05 1994 - 09:57:46 CET