Tracing SQL of user's session in Oracle database.
Ziqing Wang · Computer Engineering and Applications Journal · 2008
In order to resolve the problem unable to obtain the SQL operations of user in audit log of Oracle 8i/9i,an approach of tracing SQL of user’s session in Oracle database is proposed in this paper,which can recover the process of user’s session in Oracle 8i/9i database.In the approach,LogMiner is used to analyse the transaction log file for extracting some key fields,by matching the relate key fields in the audit log,the SQL of user’s session from his login to logout can be perfectly recovered.The result can be used to audit the operations and protect the security of Oracle database.