Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group