Search code examples
sql-serverspringspring-roo

Monitor changes to a database in Spring


I've built a spring-roo application to manage some tables in a database(SQL Server). The application is complete but one of my requirements is for Admin users to (within the application) be able to view all changes made to the database. I'm using Hibernate as my DAO. I don't know where to start with this. Any help would be appreciated. Thanks in advance.


Solution

  • You can use audit tables and enable access only to admin users or implement role based access in your application.

    Auditing
    Role-Based Access Control (RBAC)