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

Re: Single Row Table?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Single Row Table?
Date: 2004-08-31 21:09:30
Message-ID: ch2pea$ad9$ (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 NolanDate: 2004-08-31 21:15:23
Subject: Re: Single Row Table?
Previous:From: Tom LaneDate: 2004-08-31 20:59:04
Subject: Re: Single Row Table?

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