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?
Printable View
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?
You can do either of the following,:eek:
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.:D
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.