Adrian Klaver wrote: > 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)
and make sure not to give any other users insert/update/delete permissions on the audit table. > > Thanks in advance, > > > > Miles Elam > > -- > Adrian Klaver > adrian.kla...@aklaver.com
