Limited rights for a user - Mailing list pgsql-general

From Guillaume Lémery
Subject Limited rights for a user
Date
Msg-id 3A7588B9.5020005@comclick.com
Whole thread Raw
List 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.


pgsql-general by date:

Previous
From: "Mayers, Philip J"
Date:
Subject: Casting macaddr types to text
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Re: Timeouts on connections