On Wed, Jun 30, 2004 at 13:21:00 +0100,
> If I revoke insert,update,delete privileges on a table, would
> the user still be able to affect data manipulation through a
> function? Is that another way of getting around this?
If you use a security definer function where the function creator
has access to the table, but others don't then you can do that.
There are some issues if you start using such functions in views,
but for simple usage it will do what you want.
In response to
pgsql-general by date
|Next:||From: Adam Witney||Date: 2004-06-30 14:02:33|
|Subject: Re: DML Restriction unless through a function|
|Previous:||From: joseph speigle||Date: 2004-06-30 13:48:27|
|Subject: Re: mysql2postgres has no documentation?|