sys_context('userenv', 'os_user') windows user domain

michellenweiter · Post by **michellenweiter** » Fri 21 Jul 2006 06:07

Hello,

When I start a session with the orasession against an oracle DB (9i or 10g) and ask on the DB server for the OS_USER, I don't get and see the windows domain user (not domain\user, but only user). our windows XP computers are all part of a windows domain, and I was expected, like for any other applications, to see the windows domain too in the sys_context OS_USER variable when I start a session with ORASESSION.

Is there a way to make the windows domain user appear in the Oracle session information for ODAC ?

We use ODAC NET 5.79 on Delphi 2005

Thanks a lot for your help
mitch

Plash · Post by **Plash** » Mon 24 Jul 2006 08:26

There is no such way.

michellenweiter · Post by **michellenweiter** » Mon 24 Jul 2006 10:14

Could it be added in a future release?

Plash · Post by **Plash** » Wed 26 Jul 2006 11:21

We will consider the possibility of adding this feature.

michellenweiter · Post by **michellenweiter** » Wed 26 Jul 2006 14:44

It would be REALLY IMPORTANT to us to make the security much better.
Today, we cannot know if the logged on OS user was authenticated locally on the computer or by wich microsoft domain (Active directory).

We need to write extra code for that, but it would be really better to have this information as part of the Oracle session information.

Thanks anyway to take this requierement in consideration.

(suggestion: for compatibility convenience, I would add an option if we yes or no want to enable the domain information)

Plash · Post by **Plash** » Mon 31 Jul 2006 09:54

Please inform us whether you use Net option to connect to database.

michellenweiter · Post by **michellenweiter** » Mon 14 Aug 2006 09:30

Yes we do use the NET option.

Plash · Post by **Plash** » Wed 16 Aug 2006 14:10

This feature support is quite complex (as many other Net option features) and we will consider your suggestion, to include it in one of the next ODAC versions. I can't give you an approximate term of implementation, but I guess it will not be available in the nearest future.

michellenweiter · Post by **michellenweiter** » Wed 16 Aug 2006 14:16

I'm sure a lot of developers will really apreciate and the security will be much stronger and easier to handle.

Thanks a lot to take it in consideration.