| Detecting full DOMAINNAME\USERNAME for connected user [message #479958] |
Wed, 20 October 2010 08:34  |
elutsky
Messages: 10
Registered: July 2010
|
Junior Member |
|
|
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:
MYDOMAIN\Administrator from machine A, and
administrator from machine B.
Both machines are belongs to same windows domain.
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)?
Thank you in advance!
[Updated on: Wed, 20 October 2010 08:36] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Detecting full DOMAINNAME\USERNAME for connected user [message #480224 is a reply to message #480196] |
Thu, 21 October 2010 15:52  |
elutsky
Messages: 10
Registered: July 2010
|
Junior Member |
|
|
Michel,
Thank you once more about your help.
Unfortunately, I'll be able to re-test it only on Sunday.
I think I did changed the right place ( I changed it on client machine, not same with db running on it), and as a result I saw same entrances into the v$session.
Just to describe my situation better, I mean something like this:
CODE
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, my question is: When I logged in on the computers MyPC, MyPC2 and MyPC3 with domain user, lets say MyDomain\Administrator, I see in v$session described entries.
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"?
3. Why for same program (rows 2. and 4.) I see different representations in the view?
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?
Once more thank you!
|
|
|
|
|
|
| Re: Detecting full DOMAINNAME\USERNAME for connected user [message #480427 is a reply to message #480262] |
Sun, 24 October 2010 01:58 |
elutsky
Messages: 10
Registered: July 2010
|
Junior Member |
|
|
Quote:
1. Different drivers, SQL Developer uses JDBC Thin driver (default connection type), in this case no domain when your application uses OCI which set the domain accordingly to the parameter I gave.
2. Thin driver does not set this value.
3. It depends on what type of connection you choose in the connection box.
Hi Michel,
Thank you very much for your help, I am really appreciate this.
I'll make little more research / tests in nearest several days with this issue.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
