Method and apparatus for tracing data in audit trail, and computer product
In an information system, a web server records web access logs of a client outside of a LAN. A mail server records transmission/reception logs of e-mails. A DB server records access right operation logs. A task application server records DB access log. An administrative server collects logs recorded in the web server, the mail server, the DB server, and the task application server, and operation logs of the client terminals to trace a person and an operation related to information leakage using the collected logs.
1. An apparatus comprising:
a computer processor to:
receive a search condition for tracing an access to target data stored in a database;
search, from among access logs that are recorded in the database in response to accessing to the database, a first log that meets the search condition;
identify, based on the first log, a server from which the access to the target data has been possible at a time identical to a time recorded in the first log;
search, from among log records stored on the server, a second log corresponding to the first log;
identify a client that has made the access to the target data, based on the second log;
search, from among operation logs of the client stored in a storage of the client, an operation log that is recorded after the client has obtained the target data; and
output a result of tracing the access to the target data, based on the searched operation log.
2. The apparatus according to claim 1 , wherein:
a user identification (ID) of the client is correlated to a session ID of the first log;
the server is correlated to the session ID; and
the user ID is traced from the server.
3. The apparatus according to claim 1 , wherein the computer processor identifies the server by referring to an access right administration operation log.
4. The apparatus according to claim 1 , wherein the computer processor calculates a suspicion degree of the client based on the operation log.
5. The apparatus according to claim 4 , wherein the computer processor calculates the suspicion degree based on an operation recorded in the operation log.
6. The apparatus according to claim 4 , wherein the computer processor calculates the suspicion degree based on consecutive operations recorded in the operation log.
7. The apparatus according to claim 4 , wherein the computer processor calculates the suspicion degree based on an operation time recorded in the operation log, the operation time at which an operation is performed.
8. A computer-implemented method utilizing a computer processor for performing an audit trail, comprising:
receiving a search condition for tracing an access to target data stored in a database;
searching, from among access logs that are recorded in the database in response to accessing to the database, a first log that meets the search condition;
identifying, based on the first log, a server from which the access to the target data has been possible at a time identical to a time recorded in the first log;
searching, from among log records stored on the server, a second log corresponding to the first log;
identifying a client that has made the access to the target data, based on the second log;
searching, from among operation logs of the client stored in storage of the client, an operation log that is recorded after the client has obtained the target data; and
outputting a result of tracing the access to the target data, based on the searched operation log.
9. A non-transitory computer-readable storage medium that stores a program causing a computer to execute a procedure, the procedure comprising:
receiving a search condition for tracing an access to target data stored in a database;
searching, from among access logs that are recorded in the database in response to accessing to the database, a first log that meets the search condition;
identifying, based on the first log, a server from which the access to the target data has been possible at a time identical to a time recorded in the first log;
searching, from among log records stored on the server, a second log corresponding to the first log;
identifying a client that has made the access to the target data, based on the second log;
searching, from among operation logs of the client stored in a storage of the client, an operation log that is recorded after the client has obtained the target data; and
outputting a result of tracing the access to the target data, based on the searched operation log.