Design and Performance Analysis of a Secure Multi-User Database with Role- Based Access Control and Audit Trail

In multi-user database systems, guaranteeing both secure access and traceability is essential. This research introduces a relational database architecture leveraging Role-Based Access Control (RBAC) and comprehensive Audit Logging. Users are classified into Admin, Editor, and Viewer roles, each assigned distinct permissions. Every database operation is recorded to ensure accountability. Through performance tests measuring query latency and storage impact, we find that adding role enforcement and logging results in a minor slowdown—well within acceptable limits for most institutional use cases. This balance makes the system practical for environments demanding both security and transparency.