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$1@sea.gmane.org (view raw or flat)
Thread:
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.

Cheers
Thomas


In response to

Responses

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-2014 The PostgreSQL Global Development Group