Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External identification in Oracle through SQL*net
cvin_at_novo.dk writes:
> The setup is as follows:
> OS: OpenVMS 7.1 (remote_os_authent = FALSE, os_authent_prefix = '')
> DBMS: Oracle 8.0.3
> SQL*net: Net8
>
> The users have been set up to be identified externally. I.e. they can login to
> OpenVMS using their os_userid and os_password and thereafter they can login to
> Oracle by issuing for example 'sqlplus /'. This works fine. If the user on the
> other hand wants to access Oracle directly through Net8 this is not possible.
> Do you know of any workarounds? (I don't want to set remote_os_authent = TRUE)
>
> Is there some way I can set up SQL*net to authenticate users using the
> authentication system provided by the operating system hosting it (e.g.
> OpenVMS) and thereafter do ops$login?
The only way that I know of is to use the Oracle Advanced Security option
(formerly known as the Advanced Networking Option) to authenticate users.
However, that only uses SSL or third party mechanisms such as Kerberos, not
operating system authentication.
--
Rick Rick Wessman Security and Directory Technologies Server Technologies Oracle Corporation rwessman_at_us.oracle.comReceived on Mon Feb 08 1999 - 06:59:20 CST