Re: Event Triggers and GRANT/REVOKE - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Event Triggers and GRANT/REVOKE
Date
Msg-id 80a52d0f-497b-daf5-c1b4-40dc1fad70d0@aklaver.com
Whole thread Raw
In response to Event Triggers and GRANT/REVOKE  (Miles Elam <miles.elam@productops.com>)
Responses Re: Event Triggers and GRANT/REVOKE
List pgsql-general
On 10/9/19 1:56 PM, Miles Elam wrote:
> 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?

What is the code for trigger and function?

> 
> 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
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: plpgsql copy import csv double quotes
Next
From: Miles Elam
Date:
Subject: Re: Event Triggers and GRANT/REVOKE