Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGGza-00000002CRy-10XB for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 14:27:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xGGzZ-000000094eg-17EX for pgsql-general@arkaria.postgresql.org; Mon, 12 Oct 2026 14:27:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xGGzY-000000094eY-3do6 for pgsql-general@lists.postgresql.org; Mon, 12 Oct 2026 14:27:04 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xGGzV-00000001iHu-1l5r for pgsql-general@postgresql.org; Mon, 12 Oct 2026 14:27:03 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-c2e8e738ae0so306709166b.1 for ; Mon, 12 Oct 2026 07:27:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1791815220; x=1792420020; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to:content-type; bh=NrKlTb4eMLIP4TyAzSVQcPW2XL3KIz4cVNDKP0yHvLk=; b=p7t0C0RVCPoxp5lHzxJgrz6Hdz84grNqLRxLZjnI3CPTlD1Q0f07elvs5D8zDeCApd 3X2w1NLUg2fbDsFxtvRxeJwhTfPvIK7UgTSWOREhlIM5xTj9Za5VFhMMMa3AUubO7FqW mQue2to3iBzJaq/wYcXfQIWmOzycrzu0aEt++w8IV6qOI5Q9nFvbi4PEBX0iKLuz6iVn BDIAgwNle2DNEWVIdX9we8nRJh6wYavdoeLapQxR5yjs9JvKpKbjqGLLzdhtiqdWsXxd IoEPU3rmBo4U16p9e9Yx/2qCU0iiaX8c4AcUmji6Z3epnVMSRac0p87cDWpQllUh3n31 H48A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1791815220; x=1792420020; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=NrKlTb4eMLIP4TyAzSVQcPW2XL3KIz4cVNDKP0yHvLk=; b=hhsalg4uRoMLiY8CjTZIXLifH0bZiQOLNwYjP105Rgo38Pe09lc3FztKkZO2Gl8HMy NtkUQz9sSHejn3+LD9Jdo42vQvbUozGFaPpvRMvFTDpHpHAQmPK/2l+8g2dqUG1ELbEs P/1JmPlkPqnZtb3QHkVRDyIZo95PIEhyjWTbN2N58k+skxLsCq9+q5eaFpETxoa+HaEH bZLWcWcP3iTcwln00t3wIGY1J7FNUqBS8iWlRD5yP6a4rn0eTtne0muXAad3pYisc7mU 2WLGAF2Nmv4SbR6qgUFZ+CxfWozTimyvLUf0jbe0wWh9wWRot2E5y3avQ9hNheLiOh1q FitQ== X-Forwarded-Encrypted: i=1; AKwUvBxKhfTAVOWwoExeKBRfpGBFfS0GAT26XkMrdBmtLTMtutWknCR/3vVSwVKQR20iwf47zmlesFDJ8XpH+8+1@postgresql.org X-Gm-Message-State: AFq9FYIXWyUOH/ERo/7Sl2p/Tg5ql0Yqwdr7fH0Xf6kTKEWrIly36mF+ 9dSpY2Nhft74rpgXP3r0l1+422aobPREYG1rG+VUVh/Y/hGHH8OziiffIypEI88gaJ4= X-Gm-Gg: AYBFou30vNEI98mo3Gyb6bPPLLg4xWJv37SLiFIH/celtVB4WV3Nh3fQY7i5KVSD49B Ur7tuAgFDRvigAeJEG4USVaCIp//cr9uUVLjLjuHZFVfpPYKraYSR8ySNz1jo0eXF0x5dcut/lQ wRP8fBb1DUA5wInsFG1mdG1vcnJkn3eurzblfi6A6toBVCLDNuBfsTkr/pRssB/fAIpYYF20KHt LzsFP5PKaMOuQ5AigcKswaR2AKCfS0t3CwRVmXGqWcaltcIoY6niC8WdT5B8vnuS1PwjezrWvhd t9gzn8QrpvPzuIT2gMEvFCRPzRLt0vYiyKhSx4Nr0eGNAXd7gJdHN63WKttx2JJdPsNkphLK9RZ 5Dr65YrhXPbrsxdQ4TM5guvuqDHZ+MKIdixkEKQerOa+CiYbGaVTidUw3AHPsfyl8GLS3fhQqbq a0I+RAxs1fHAi0PxXY3omr50NHD6DYpUAgFmnNkPwdKsSauh/3A9l2UqavTKNKbKz015PHzW0XO y7IK/4r/gizY2vlCG6U89tsuIKe X-Received: by 2002:a17:906:7947:b0:c2d:c739:30e1 with SMTP id a640c23a62f3a-c31a9f8d670mr955400866b.32.1791815220019; Mon, 12 Oct 2026 07:27:00 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:a373:9e7d:4105:daab:5c6c]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-c356f981cd3sm86238566b.83.2026.10.12.07.26.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 12 Oct 2026 07:26:59 -0700 (PDT) Message-ID: <47ec6533d8da7e176b8e6bb167feb3d82313eed8.camel@cybertec.at> Subject: Re: pg_event_trigger_ddl_commands after GRANT is quite empty From: Laurenz Albe To: =?ISO-8859-1?Q?F=E4rber=2C?= "Franz-Josef (StMUK)" , "pgsql-general@postgresql.org" Date: Mon, 12 Oct 2026 16:26:58 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-10-12 at 08:47 +0000, F=C3=A4rber, Franz-Josef (StMUK) wrote: > pg_event_trigger_ddl_commands after GRANT is quite empty. >=20 > If I execute: GRANT SELECT ON TABLE t TO r; >=20 > . and in a trigger function I have: >=20 > SELECT classid, objid, objsubid, command_tag, object_type, schema= _name, object_identity > FROM pg_event_trigger_ddl_commands(); >=20 > This gives me: >=20 > null, null, null, GRANT, TABLE, null, null >=20 >=20 > How to find out the table involved and the privileges? I think you have to write a C function that can do something with pg_ddl_command. Yours, Laurenz Albe