Limited rights for a user

From: Guillaume Lémery <glemery(at)comclick(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Limited rights for a user
Date: 2001-01-29 15:14:01
Message-ID: 3A7588B9.5020005@comclick.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I grant to one user only the SELECT action on my tables.
But I'd like he could update some data without granting him the UPDATE
right...
Is it possible to put the UPDATE in a function and then the user can
UPDATE the data by usinf this function ?

Or I must grant him the UPDATE right ? (which is a big security limit...)

Thanx.

Guillaume.

Browse pgsql-general by date

  From Date Subject
Next Message Camm Maguire 2001-01-29 15:16:16 Re: Calculated values
Previous Message Mayers, Philip J 2001-01-29 15:10:21 Casting macaddr types to text