Oracle Database Discussions

Hi,

If I'm looking on v$session - values in osuser column for some machines displayed with DOMAINNAME, and for other - without.
Even same user (MYDOMAIN\ADMINISTRATOR) from 2 different machines displayed in 2 different ways on the same db:

MYDOMAIN\Administrator from machine A, and
administrator from machine B.

Both machines are belongs to same windows domain.
DB (oracle 10g) have no "DOMAIN" defined.

What make the difference?
And can I somehow to affect this behaviour? I mean, can I define that all users will be displayed as DOMAINNAME\USERNAME or MACHINENAME\USERNAME(in case of no domain exists)?


May be I described myself wrong:
When I logged in on the computers MyPC, MyPC2 and MyPC3 with domain user, lets say MyDomain\Administrator, I see in v$session 4 entries:


OSUser || Machine || Terminal || Program
----------------------------------------------------------------------------------------------
1. MyDomain\Administrator || MyDomain\MyPC || MyPC || devenv.exe
2. Administrator || MyPC || UNKNOWN || SQL Developer
3. Administrator || MyDomain\MyPC2 || MyPC2 || MyApplication.exe
4. MyDomain\MyUser1 || MyDomain\MyPC3 || MyPC3 || sqldeveloper.exe


So ,the questions are:
1. Why, even for same machine and same logged in user (rows 1. and 2. ) I saw different entries in the OSUser name field and Machine field?
2. Why "terminal' can be "unknown"?
2. Why for same program (rows 2. and 4.) I see different representations in the view?


I have to say that I know that username in v$session can be used for oracle user identification, sid and serial# can be used for unique session identification, and so on.
Also, before I posted my question I read a lot about os_authent_prefix and remote_authent_prefix options, as well as about OS Authentication, proxy user authentication, pre-defined "DOMAIN" parameter in configuration files and so on.

We are not using one of this techniques, we are not using os authentication, connected programs as you can see are not proxy-style applications, ...

I just try to understand why for same domain user logged in on as domain user on the same machine, oracle can display DomainName\UserName in one case, and just user name in another?

May this be somehow related on remote connection (in case of row 2)? I think, this possibly can describe terminal="unknown" but this will not describe row 3 behaviour.

Because of different representation in the same db - I thinking may be there are some clients definitions? Network Listener definitions?


*Thank you with advance!*

Edited by: user13133099 on Oct 21, 2010 4:49 AM