Skip to content

sql: implement an audit log for connections and authentication attempts #45715

@knz

Description

@knz

This is a feature ask by a paying customer.

The need is to provide an opt-in logger for SQL client connections (opening the SQL port), and another opt-in logger for SQL authentications (indicating which user logs in from where using which auth method and whether it is successful/rejected).

Note that this issue is specific to SQL client conns. Audit logging for other types of connections (UI, RPC etc) is covered by the separate issue #45716

Metadata

Metadata

Assignees

Labels

A-securityA-sql-pgwirepgwire protocol issues.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions