Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
05-04-2007
|
|||
|
|||
|
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 |
|
05-04-2007
|
|||
|
|||
|
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-
|
|
07-12-2007
|
|||
|
|||
|
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.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear 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 09:43 AM.
