Postgres Pro
Downloads
Home   >   mailing lists

Inserts restricted to a trigger - Mailing list pgsql-general

From Miles Elam
Subject Inserts restricted to a trigger
Date
Msg-id CAALojA-Mn+V+j9gdS2-jyoCzAGrjwGQh2hJq0H1it5M4=UaHBw@mail.gmail.com
Whole thread Raw
Responses Re: Inserts restricted to a trigger
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: perf tuning for 28 cores and 252GB RAM
Next
From: Tim Cross
Date:
Subject: Re: psql UPDATE field [tab] expands to DEFAULT?