Priviliges and Roles

From: Dayo Johnson <dayoj(at)cleanjohn(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Priviliges and Roles
Date: 2006-02-27 12:09:48
Message-ID: 4402EC0C.9030903@cleanjohn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

Is it possible to do the following:
Disallow permission to write to a table (either by UPDATE or INSERT) but
allow EXECUTE permission on a Function that writes to the table ?

The reason I want to do this is so that I can perform certain checks on
the data that is being written before I allow it to be written.

Cheers DayoJ

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam 2006-02-27 12:21:51 Re: Priviliges and Roles
Previous Message Michael Fuhr 2006-02-27 06:03:34 Re: Reg: Multiplequeries pls help me