pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Cotton <scott.cotton@gmail.com>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: can't revoke users
Date: Mon, 11 Feb 2008 10:46:49 -0600
Message-ID: <47B07BF9.4050805@gmail.com> (raw)
In-Reply-To: <4544e0330802110805y5fe7a3fdm5febcd64aad95f2c@mail.gmail.com>
References: <2526be2b0802081601k64eb324dk8ac776659347ecde@mail.gmail.com>
	<4544e0330802110805y5fe7a3fdm5febcd64aad95f2c@mail.gmail.com>

This is on 7.4 running on CentOS.

I think I've narrowed the issue down. The problem is in some cases the 
permissions for the bad users were granted by one of the bad users. So 
even if I'm logged in as the table owner, I can't revoke privileges on a 
user that was granted privileges by another user. And I can't revoke 
privileges on the bad user that granted privileges to other bad users. 
And in some cases the postgres user set the privileges, and I can't do 
anything with them.

So I've been trying different combinations of logging in as different 
users and revoking privileges. Some things work and some things don't. 
It really it seems like the table owner should be able to revoke any 
privileges in their table, but this isn't the case.

The biggest problem I'm having is that the postgres user can't revoke 
anything for users that it granted privileges for.

Scott

Peter Koczan wrote:
> On Feb 8, 2008 6:01 PM, Scott Cotton <scott.cotton@gmail.com> wrote:
>   
>> I have a database that I dropped some users on. However, when doing dumps
>> and restores, it became clear that these users were still being referenced
>> by sysid. So I created new users and assigned them the sysids of the users I
>> had dropped.
>>
>> So now I went to revoke the privileges for the new (temp) users. However,
>> some tables I can revoke the users and some I cannot.
>> I also tried to drop one of the new users I created and it created the same
>> situation as before, where the user still shows up with priveleges, but
>> instead of listing a name it lists a sysid.
>>     
>
> I've had to deal with stuff like this before.
>
> What exactly are the errors are you getting, and what version of
> PostgreSQL are you running?
>
> Peter
>
>   

view thread (3+ messages)

Message-ID: <47B07BF9.4050805@gmail.com>
Permalink:  ../47B07BF9.4050805@gmail.com/
Also on:    postgresql.org/message-id/47B07BF9.4050805@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.cotton@gmail.com, pjkoczan@gmail.com
  Subject: Re: can't revoke users
  In-Reply-To: <47B07BF9.4050805@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox