Re: Inserts restricted to a trigger

[Adrian Klaver]

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.kla...@aklaver.com