pg.ddx.io  pgaudit/pgaudit GitHub issues and pull requests  
help / color / mirror / Atom feed
[pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
6+ messages / 2 participants
[nested] [flat]

* [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2023-02-28 17:31 "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
  0 siblings, 0 replies; 6+ messages in thread

From: fabiobaiao (@fabiobaiao) @ 2023-02-28 17:31 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

An 

```sql
INSERT INTO "table"("col1", "col2") VALUES ('foo', 'bar') RETURNING "col1";
```
with a 

```sql
GRANT SELECT("col2") on TABLE "table" TO "auditor";
```

emits an audit log.

It seems that the `insertedCols` are being checked against both the `INSERT` and `SELECT` grants, whilst I guess it should be checking the latter grant against the `selectedCols`.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2023-02-28 17:31 ` "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: fabiobaiao (@fabiobaiao) @ 2023-02-28 17:31 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@fabiobaiao renamed this.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-06-26 03:39 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele assigned @dwsteele.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-06-26 03:39 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele applied label "bug".

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-06-26 03:45 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

@dwsteele closed this.

^ permalink  raw  [nested|flat] 6+ messages in thread

* Re: [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected
@ 2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
  4 siblings, 0 replies; 6+ messages in thread

From: dwsteele (@dwsteele) @ 2026-06-26 03:45 UTC (permalink / raw)
  To: pgaudit/pgaudit <noreply+pgaudit-pgaudit@github.com>

This is fixed in PR #323.

^ permalink  raw  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2026-06-26 03:45 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-28 17:31 [pgaudit/pgaudit] issue #205: `INSERT` with `RETURNING` emits a log over a column that's not being selected "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
2023-02-28 17:31 ` "fabiobaiao (@fabiobaiao)" <noreply+fabiobaiao@github.com>
2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:39 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>
2026-06-26 03:45 ` "dwsteele (@dwsteele)" <noreply+dwsteele@github.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox