Home » SQL & PL/SQL » SQL & PL/SQL » How to find the from which channel request came (oracle 10g)
How to find the from which channel request came [message #404744] Sat, 23 May 2009 03:36 Go to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
Hi,
We have application developed in Java.It has a front end through which user can change his password password,which is stored in a table in backend(table).
Now I need to fix following scenario.
If I change my password through front end ,It would be changed in table,but if I try to change the password using schema user/pwd through backend by directly updating in table,the system should log that entry in another table specifing which schema user changed password column in that table through backend.we don't require this logging while changing through front end

Please suggest the way to do this.

Regards,
Navneet

[Updated on: Sat, 23 May 2009 03:42] by Moderator

Report message to a moderator

Re: How to find the from which channel request came [message #404746 is a reply to message #404744] Sat, 23 May 2009 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The best way is to not allow direct updates on this table but use a procedure to do so.
This procedure can then do it wants like checking who calls it.

Regards
Michel
Re: How to find the from which channel request came [message #404748 is a reply to message #404746] Sat, 23 May 2009 03:50 Go to previous messageGo to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
Thanks Michel,
But that is my problem.how would I check through which channel request has come for update.Are you suggesting that I should also pass some flag through front end for identification?

Point to note is ,We need to allow direct updates through backend and in this case we need to log this change to some history .

Regards,
Navneet

[Updated on: Sat, 23 May 2009 09:32] by Moderator

Report message to a moderator

Re: How to find the from which channel request came [message #404766 is a reply to message #404748] Sat, 23 May 2009 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Stop using quote tags if you don't quote.

Quote:
Point to note is ,We need to allow direct updates through backend and in this case we need to log this change to some history .

So the procedure is still the best way, it can logs when it wants to log and does not when it does not want to log.

Quote:
But that is my problem.how would I check through which channel request has come for update.

What "channel" means for you?

Regards
Michel
Re: How to find the from which channel request came [message #404787 is a reply to message #404766] Sat, 23 May 2009 15:52 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
read about DBMS_APPLICATION_INFO and database triggers (table triggers and instead-of-triggers). These will give you ideas on how to solve your problem.

Kevin
Previous Topic: PARTITIONS missing
Next Topic: Delete 5 million records
Goto Forum:
  


Current Time: Thu Feb 13 23:51:09 CST 2025