We have a 8.1.7 database running on a NT box. Our customers use Query Builder for running adhoc queries. But it has a data editor that can not be disabled even though Oracle says, in its online documentation, that it is shipped disabled. To prevent users from executing DML from this product, I was trying to write triggers on tables that will return an error if the host program is OBE60.EXE which is query builder. I tried to query PROGRAM column of V$SESSION view but it is only 64 char long. Since it has folder names also, this may not give the actual program name at all. So, is there any other way to find the program name?

Sanjeev