Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External authentication
On Wed, 6 Feb 2002 17:21:45 +0100, "Stjepan Brbot"
<Stjepan.Brbot_at_ZG.HiNet.HR> wrote:
>"I hate Spam" <tbf_at_cn.stam.dk> wrote in message
>news:7gg26u4kbviemuguf5lg7fhl9blfb6i0kp_at_4ax.com...
>> On 5 Feb 2002 22:04:42 -0800, future_canadian_at_hotmail.com (F C) wrote:
>>
>> >I had the same problem and recently got the answer from this NG.
>> >
>> >In Oracle, assuming that the authentication prefix is an empty
>string,
>> >include the computer name in the username, like PC100\USER. Use
>double
>> >quotes and uppercase letters. Log on Windows as USER. That should
>> >work.
>>
>> If you are logged on a domain it should be the domain name.
>
>Unfortunately my comp is not yet in domain, at this moment this is
>standalone server in worgroup model of LAN. So authentication should be
>performed by my local OS (Windows 2000 Pro) not DC (AD). This user
>defined for external authentication in Oracle database is local
>username/password not network username/password.
I think you missed my point. If you are logging on authenticated by a
local W2K you should use "computername/username" as the user name in
Oracle. Then you have to use that specific computer to log on with OS
authentication
If you are autenticated by a Domain Controller you should use
"domainname/username" as the username in Oracle. Then you can log on
with that username on any computer in that domain using OS
authentication.
Yours Hans Erik Busk
tbf_at_cn.stam.dk
Received on Thu Feb 07 2002 - 02:51:32 CST