Re: ops$ logins from both secure and nonsecure clients with same username

Mark Citron (mcitron_at_hsc.usc.edu) wrote: [...]
>What about the same user that connects from both secure and non secure
>platforms at different times. Can the ops$ (when set to null) handle
>that so that it does not ask for a password from unix but does from
>windows?
>How do you define the password in that case (only one Oracle username
>for both secure and nonsecure clients).

The setting of OS_AUTHENT_PREFIX (to "" or "ops$") only determines how the Oracle userid is formed from whatever Oracle thinks the client's OS userid is. It sounds like you are asking for Oracle's authentication behavior to vary depending on the type of system on which the client runs. That isn't possible in the current product as far as I know, but you might want to investigate Oracle Secure Network Services to see if it has facilities that might meet your needs.

/b

--
Bill Manry  -  Mainframe and Integration Technologies  -  Oracle Corporation
These are my opinions, not necessarily Oracle's.