|
|
| Re: test : a question on tracking [message #177537 is a reply to message #177534] |
Thu, 15 June 2006 06:14   |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
--continuously getting message that your session expired..can you please help..also please see my question below
Hi Experts,
I have a very interesting issue on the above. The scenario is:
We have a web application with oracle as the data tier. All application users who log to the application use a common database account... (E.g. if the application has 60 users, (named m, n etc) when they connect to the database, at the database level the schema is only one (i.e. abc). So when user m connects then also the database user is abc and when n connects then also the database user is abc. (Ie. In the database the session is created with userid of “abc”)
Now we want to implement auditing and we need to track which application user has made what change. i.e. if user m changes a table emp and adds a record then in an audit table a row should be added WHICH HAS THE USER M. similarly if N does it then the row for user N has to be there. But how do we track the application user because at the database level we do not have application user at all!
(Oracle version 9.2.0.6)
--
A few solutions that occur to me but need to work out their details are: Is there a way like sys_context or Fine grain auditing for this? For example by creating a database wide logon trigger and using sys_context etc?
Shall be very thankful for your inputs..
Nirav
[Updated on: Thu, 15 June 2006 06:18] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
