| v$session issue [message #379251] |
Mon, 05 January 2009 12:25  |
sant_new
Messages: 165
Registered: June 2008
|
Senior Member |
|
|
Hi all,
Happy New year!!
We have a function called gosuser, which basically gets the osuser from v$session. Our client has reported a problem that when they run select gosuser from dual, they get domain\username in their live database. But in their test database they only get the username. Both databases reside on the same server. Since our application does not support '\', we have a constraint for a column that is getting the value from the gosuser function.
One of the option here will be to drop the constraint to allow '\' for that column. But, does anyone know why we get two different values, when both the databases reside on the same server?? Could it be some OS configuration or will it be a database setting??
Thank you.
|
|
|
|
|
|
|
|
| Re: v$session issue [message #379259 is a reply to message #379255] |
Mon, 05 January 2009 13:09  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Well, something MUST be different between the two.
Maybe you could try to pin down the problem, and see where the difference starts to show up. What is the result of these both from test and production:
From the Windows command prompt on the client :
from SQLPlus on the client :
SELECT sys_context('USERENV', 'OS_USER') FROM dual;
select banner from v$version;
and look for differences there.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
