Database Transactional Based Fraud and the Halloween Problem are significant concerns in the realm of database security. Malicious transactions pose a risk to data integrity and availability, yet detecting and identifying attackers executing such transactions remains a challenge. This article explores the concept of Database Malicious Transactions Detector (DBMTD), a proposed mechanism consisting of transaction profiling and intrusion detection phases. It discusses the importance of transaction profiling in identifying authorized transactions and describes the auditing mechanism that collects crucial information about executed commands. Additionally, the article delves into the infamous “Halloween Problem” in SQL UPDATE queries, highlighting the need for proper handling of database changes to avoid unintended consequences. By understanding these concepts, organizations can enhance their database security measures and protect against transactional fraud while ensuring accurate and efficient data management.