Re: Logon denied - externally authenticated user over a workgroup ...

Toby Edwards wrote:
> After unsuccesfully getting PO8.1.7 to work I am now trying the
> following
>
> 1 server (Win 2k server), 1 client (Win2k pro). Machines are part of a
> WORKGROUP called BATSTONE.
>
> Server running 8.1.7 Enterprise edition, sid = ORCL, following set in
> init.ora
> remote_login_password_file = none
> os_authent_prefix = ""
> remote_os_authent = TRUE
>
> On the server and client sqlnet.ora has
> SQLNET.AUTHENTICATION_SERVICES = (NTS)
>
> Created a user on the server identifed externally (the user has a
> server account)
>
> create user "IBM01\TOBY EDWARDS" identified externally;
> grant connect, resource to "IBM01\TOBY EDWARDS";
>
> Logged off Administrator, logged on as Toby Edwards -
> sqlplus / works !! (woohoo)
> sqlplus /@ORCL works !! (woohoo)
>
> Logged on the client as Toby Edwards,
> sqlplus /@ORCL fails - ORA-01017 invalid username/password; logon
> denied
>
> Back on the server created a user (BATSTONE being the workgroup)
> create user "BATSTONE\TOBY EDWARDS" identified externally;
> grant connect, resource to "BATSTONE\TOBY EDWARDS";
>
> The client still fails to logon.
>
> Interestingly in the Oracle Admin Assistant, if I choose to create an
> external user I can only select those users created on the server. In
> my live environment the database server is seperate from the domain
> controller so similarly does not display users in the domain.
>
> Any help greatly appreciated
>
> Toby

log onto remote client as "TOBY EDWARDS" log into Oracle as "TOBY EDWARDS" from remote client.

what does
SELECT USERNAME, OSUSER, MACHINE FROM V$SESSION; report? Received on Sun Nov 23 2003 - 08:24:28 CST