Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> That was one of my first guesses as well, but then I'm not sure if you can
> revoke DELETE and INSERT privilege from the owner of the table...
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.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Thomas Kellerer||Date: 2004-08-31 21:09:30|
|Subject: Re: Single Row Table?|
|Previous:||From: Joe Conway||Date: 2004-08-31 20:54:41|
|Subject: Re: Large Databases|