Devart Forums

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

There is no such way.

Could it be added in a future release?

We will consider the possibility of adding this feature.

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)

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

Yes we do use the NET option.

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.

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.