PR #104372 - sql: add sql.log.user_audit.reduced_config.enabled to support single

[cockroach-teamcity]

Exalate commented:

Related PR: cockroachdb/cockroach#104372
Commit: cockroachdb/cockroach@3341bcf
Epic: CRDB-8035
Informs: CRDB-26452

---

Release note (sql change): Introduce new cluster setting
sql.log.user_audit.reduced_config.enabled. When enabled, this cluster
setting computes a "reduced" audit configuration based on the user's
current role memberships and the current value for the
sql.log.user_audit cluster setting. The "reduced" audit configuration
is computed at the first SQL event emit by the user after the setting
is enabled. Enabling the cluster setting allows us to compute the audit
configuration once at session start, instead of computing at each SQL
event (providing ~5% increase in throughput). The tradeoff is that
changes to the audit configuration (user role memberships or cluster
setting configuration) are not reflected within session. Users will need
to start a new session to see these changes in their auditing behaviour.

https://cockroachlabs.atlassian.net/browse/DOC-1355 #Informs:
cockroachdb/cockroach#33316 #Epic: CRDB-8035

Jira Issue: DOC-7853