Data access and user id

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Data access and user id
Date: 2009-11-21 16:08:09
Message-ID: 4B081069.7020907@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma 2009-11-21 16:24:47 Re: Data access and user id
Previous Message Alan Hodgson 2009-11-21 00:05:09 Re: pgsql cluster