Inserts restricted to a trigger

From: Miles Elam <miles(dot)elam(at)productops(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Inserts restricted to a trigger
Date: 2019-06-17 23:54:51
Message-ID: CAALojA-Mn+V+j9gdS2-jyoCzAGrjwGQh2hJq0H1it5M4=UaHBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks in advance,

Miles Elam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Cross 2019-06-18 00:09:11 Re: psql UPDATE field [tab] expands to DEFAULT?
Previous Message Jeff Janes 2019-06-17 23:45:41 Re: perf tuning for 28 cores and 252GB RAM