cockroachdb / cockroachdb/cockroach

Have the ability to filter out internal queries when using `sql.log.user_audit` cluster setting

Open
#105,590 2 comments 0 reactions 1 assignee Claimed by @kevin-v-ngo View on GitHub
C-enhancement O-support P-3 T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Is your feature request related to a problem? Please describe.**
When using `sql.log.user_audit`, the audit log records ALL queries generated by the user, even ones that are internally created by viewing the DBConsole etc. There should be an option to only record explicit SQL queries ran externally from clients.

**Describe the solution you'd like**
A new cluster setting, which works with `sql.log.user_audit` to disable the logging of anything where the query is generated internally (e.g. ApplicationName is one of `$ internal-console`, `$ internal-check-is-admin`, etc.

Jira issue: CRDB-29113

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.