Re: O/S usercode verification
Date: Tue, 29 Nov 1994 14:52:30 GMT
Message-ID: <James.Lawrence.32.000EE079_at_epamail.epa.gov>
In article <14894313.13194.14114_at_kcbbs.gen.nz> jolly_at_kcbbs.gen.nz (John Oliver) writes:
>Subject: O/S usercode verification
>From: jolly_at_kcbbs.gen.nz (John Oliver)
>Date: 10 Nov 94 03:39:54 GMT
>Summary:
>Keywords:
>If I CREATE USER blarg IDENTIFIED EXTERNALLY, should it
>be possible to connect to the database with the usercode
>and the password of the usercode as per the O/S? e.g. in sqldba
>connect blarg/<blarg's O/S password>.
>The reason for asking is that is how I read the manual yet
>when I try it I have no joy. I checked the FAQ but couldn't
>find anything on this.
>Setup : Oracle7, O/S : SunOS 4.1.3.
>TIA.
>David.
No you can connect to the user with a connect /. No username and password, catch is the user must be logged on at the operating system level. You also must use the os_authentication_prefix which is usually ops$, IE ops$blarg. There are some other INIT.ORA parameters that enable this functionality. The assumption is if he is a valid operating system user then he is a valid Oracle user. How you do this for client server on UNIX I don't know. In the VMS world you use proxy accounts on the server. I assume there is some UNIX work alike. The only SQLDBA connect I know of that supports the operating system password is connect internal/osuser.ospw
Lawrence.... Received on Tue Nov 29 1994 - 15:52:30 CET