On Mon, 2026-01-26 at 17:44 +0000, felix.quintgz@yahoo.com wrote:
>
> Any method that allows me to know who accessed the database and when.
>
> This is necessary for auditing the database. It's a requirement for
> financial applications.
> I can't use a table within the database because it gets overwritten
> upon restoration.
>
>
A user has access to the application and logs on. You record that in a
table of successful log-ons. You also need a table of unsuccessful log-
on attempts. E.g, mis-typed password, access window expired, etc.
None of that data is lost when a database restore occurs.
You haven't said if you intend doing hot backups or cold backups.
Have you read Chapter 25 of the documentation?
>I don't have admin access to the database server; in SQL Server, I
>resolved this using signed stored procedures.
Most IT departments have a person known as the DBA. They are involved
in the design of the database to fit the application and after it goes
live are usually responsible for checking the back-ups.
You haven't stated what your role is with the development of this
application.
Rob
