pg_event_trigger_ddl_commands after GRANT is quite empty

From: Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_event_trigger_ddl_commands after GRANT is quite empty
Date: 2026-10-12 08:47:45
Message-ID: e76825ec4a93422aacf3b64f521c4ed5@stmuk.bayern.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Postgres Community,

pg_event_trigger_ddl_commands after GRANT is quite empty.

If I execute: GRANT SELECT ON TABLE t TO r;

. and in a trigger function I have:

SELECT classid, objid, objsubid, command_tag, object_type, schema_name, object_identity
FROM pg_event_trigger_ddl_commands();

This gives me:

null, null, null, GRANT, TABLE, null, null

How to find out the table involved and the privileges?

Regards,
Franz-Josef Färber

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shankar Reddy 2026-10-12 09:17:51 Missing data in a particular table
Previous Message Manu 2026-10-09 18:04:58 Re: Challenges with huge postgresql deployments in 300+ TBs