Auditing 2-tier connections - Please help!!!

[roukie_dba]

Gurus,

We have a three tier environmnet: Oracle_forms 6i Web/Middle Tier 9iAS/Oracle 9i DB back-end. Most of our users access data view JAVA client web-based applet making connections through the 9iAS server. We want to monitor all users connecting to the database in two-tier mode (e.g. SQL*PLUS/Access/Crystal...). Can someone please give me an idea as to how this task may be accomplished?

Thanks.

[marist89]

audit by session and query where hostname <> 'your middle tier'

[bkoniki]

It may help if you give bit more information.

1. If any body on the internet can access the database through java client, you might already defined fixed no of users ( say 3 ) and might have assigned suitable roles to them. In this case , it appears 3 types of users having multiple sessions to the database.

2. In the intranet case, you might have given individual user name/password to each potential userand registered in the database.


3. I don't know whether 9iAS can maintain it's own user list and connect then to the database as predefined set of users defined in the database.


Hope this helps !!