Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Keep track of the DML operations performed by several users

This is a discussion on Keep track of the DML operations performed by several users within the Oracle forums, part of the Databases category; How do I know as a developer, the IP Address of a particular machine from SQL prompt? To be precise, I need to keep track of the DML operations performed ...

Geeks Talk > Databases > Oracle Keep track of the DML operations performed by several users

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-04-2007

satyabrata_igate Junior Member   Join Date: May 2007 Location: Bangalore Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Keep track of the DML operations performed by several users How do I know as a developer, the IP Address of a particular machine from SQL prompt? To be precise, I need to keep track of the DML operations performed by several users in my DB. How do I know that without having DBA previlege?

Sponsored Links

#2 (permalink)   05-04-2007

sutnarcha Expert Member   Join Date: Nov 2006 Location: Hyd-IND Posts: 523 Thanks: 1 Thanked 55 Times in 46 Posts

Re: Keep track of the DML operations performed by several users You can do either of the following, 1) You can create an application that periodically tracks the manipulations on the database. 2) You can create database triggers that generate reports on the manipulated database contents. Both are equally complex. I would personally choose the first solution. __________________ Lack of WILL POWER has caused more failure than lack of INTELLIGENCE or ABILITY. -sutnarcha-

#3 (permalink)   07-12-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: Keep track of the DML operations performed by several users you can create a trigger on a specified event . every time that event occurs ,you can make an entry to a log table the name of the user who executed the connand and which command.

Geeks Talk > Databases > Oracle

« Creating a table by copying another table's structure | Retrieve values in different format »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MCSE 2003 track is new or .........	nikhil_rattan	Microsoft Certification	1	09-19-2008 07:28 AM
AVI Toolbox: video operations at ease.	JobHelper	Geeks Lounge	0	01-15-2007 10:50 AM
Microsoft CRM : Plan and track a winning campaign	Jim.Anderson	Microsoft CRM	0	09-27-2006 07:39 AM
Microsoft CRM : Track campaign responses	Jim.Anderson	Microsoft CRM	0	09-27-2006 07:39 AM
Microsoft CRM : Track returned products	Jim.Anderson	Microsoft CRM	0	09-27-2006 07:39 AM

All times are GMT -4. The time now is 01:33 AM.