Log Authentication Attempts for Audit
Add comprehensive audit logging for authentication attempts. Log successful logins and rate limit blocks to database table. Create admin-only UI view for querying attempts.
Note:
- Capture: timestamp, email, success/failure, IP address, user agent, failure reasons
- Storage: Database table linked to user
- Events to log: successful logins, rate limit blocks
- Retention: Indefinitely (consider lifecycle management in future)
- UI: Admin-only view for querying attempts