-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: implement an audit log for connections and authentication attempts #45715
Copy link
Copy link
Closed
Labels
A-securityA-sql-pgwirepgwire protocol issues.pgwire protocol issues.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-securityA-sql-pgwirepgwire protocol issues.pgwire protocol issues.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)