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

Re: Single Row Table?

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: spam_eater(at)gmx(dot)net (Thomas Kellerer)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Single Row Table?
Date: 2004-08-31 21:15:23
Message-ID: 200408312115.i7VLFNWT018132@gw.tssi.com (view raw or flat)
Thread:
Lists: pgsql-general
> > Why not just revoke the delete privilege?
> 
> 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...

I just did a quick test on 7.4.5.  Yes the table owner can revoke (and
re-grant) delete privileges on a table he owns, but of course I was not 
able to revoke delete privileges from a superuser, since by definition 
a superuser bypasses all access controls restrictions.

I assume the rule approach would apply to the superuser as well as to 
other users.  That makes it better able to handle this situation, whether
or not that approach has downsides is an internals question I can't answer.
--
Mike Nolan


In response to

pgsql-general by date

Next:From: Steve CrawfordDate: 2004-08-31 21:17:51
Subject: Rule/sequence weirdness
Previous:From: Thomas KellererDate: 2004-08-31 21:09:30
Subject: Re: Single Row Table?

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