Identify MS Access in Oracle Database

  • Thread starter Thread starter Liza
  • Start date Start date
L

Liza

Is there a command, function, or setup feature that I can
update or use so that when users are using ACCESS to link
to an Oracle database table, we can identify that the user
is using ACCESS.

There is a view in ORACLE that can display who is logged
into the system and what application they are using, for
our MS ACCESS users, their module name is BLANK.

Thanks!
Terry
 
If you have access to the Oracle View (v$session), this should give you the information

Select username, program from v$session;

our program is described as msacess.ex

Hope that helps
Kathy
 
as v$session is a restricted view (sysdba) you may have to create a ixed
view on it
to read the data
ie
create or replace view DBA_SESSION as select * from v$session;
grant select on DBA_SESSioN TO <whoever>;

HTH
Pieter
 
Back
Top