Re: Inserts restricted to a trigger

On 6/17/19 4:54 PM, Miles Elam wrote:
> Is there are way to restrict direct access to a table for inserts but 
> allow a trigger on another table to perform an insert for that user?
> 
> I'm trying to implement an audit table without allowing user tampering 
> with the audit information.

Would the below not work?:
CREATE the table as superuser or other privileged user
Have trigger function run as above user(use SECURITY DEFINER)

> 
> 
> Thanks in advance,
> 
> Miles Elam


-- 
Adrian Klaver
adrian.klaver@aklaver.com