Event Triggers and GRANT/REVOKE

From: Miles Elam <miles(dot)elam(at)productops(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Event Triggers and GRANT/REVOKE
Date: 2019-10-09 20:56:10
Message-ID: CAALojA9YTg1GzECnTkSnpt7pStsXdhOM132mJt4FLQUC4eVsrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

GRANT and REVOKE trigger on a ddl_command_end event trigger but don't
provide any information beyond whether it was a table, schema, function,
etc. that was affected. No object IDs or the like are included. How would
you find out which table had its ACLs modified?

Also, why do grants and revokes have an object_type of 'TABLE' instead of
lower case names like 'table' for all other event types?

Thanks,

Miles Elam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PASCAL CROZET 2019-10-09 21:20:02 plpgsql copy import csv double quotes
Previous Message Adrian Klaver 2019-10-09 20:09:39 Re: Allowing client access