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.
In response to
pgsql-general by date
|Next:||From: Mike Nolan||Date: 2004-08-31 21:15:23|
|Subject: Re: Single Row Table?|
|Previous:||From: Tom Lane||Date: 2004-08-31 20:59:04|
|Subject: Re: Single Row Table? |