Data access and user id - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Data access and user id
Date
Msg-id 4B081069.7020907@gmail.com
Whole thread Raw
Responses Re: Data access and user id  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-novice
Hi list,

I can't solve what should be a trivial problem:

I don't want users to have direct access to tables (no direct inserts,
updates & deletes), so I use views and functions for that.

My PB is I just can use triggers with SECURITY DEFINER to do that, thus
I can't update the field 'user_mod' with user's id because triggers are
always executed as their owner's id, not caller's id.

Jiff
--

pgsql-novice by date:

Previous
From: Démi Zsolt
Date:
Subject: pgsql cluster
Next
From: Richard Broersma
Date:
Subject: Re: Data access and user id