Tom Lane wrote on 31.08.2004 22:59:
> In Postgres you can do this, although I think it's contrary to the
> restrictions of the SQL spec, so it might not work in other DBs.
>
> The reason is that Postgres treats the owner's ordinary privileges
> as having been granted by the owner to himself; therefore he can revoke
> 'em too. The SQL spec treats the owner's privileges as having been
> granted by the mystical entity "_SYSTEM"; not being "_SYSTEM", the owner
> cannot revoke them.
>
> Since it's obviously useful to be able to make a read-only table,
> I think that the spec has missed a bet here.
>
Thanks for the explanation. And yes I agree with you that making a table
read only by revoking the grants is something *very* useful.
Cheers
Thomas