pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
can't revoke users
3+ messages / 2 participants
[nested] [flat]

* can't revoke users
@ 2008-02-09 00:01  Scott Cotton <scott.cotton@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Scott Cotton @ 2008-02-09 00:01 UTC (permalink / raw)
  To: pgsql-admin

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.

Any ideas?

Thanks,
Scott

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: can't revoke users
@ 2008-02-11 16:05  Peter Koczan <pjkoczan@gmail.com>
  parent: Scott Cotton <scott.cotton@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Koczan @ 2008-02-11 16:05 UTC (permalink / raw)
  To: Scott Cotton <scott.cotton@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: can't revoke users
@ 2008-02-11 16:46  Scott Cotton <scott.cotton@gmail.com>
  parent: Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Scott Cotton @ 2008-02-11 16:46 UTC (permalink / raw)
  To: Peter Koczan <pjkoczan@gmail.com>; +Cc: pgsql-admin

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
>
>   

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-02-11 16:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-09 00:01 can't revoke users Scott Cotton <scott.cotton@gmail.com>
2008-02-11 16:05 ` Peter Koczan <pjkoczan@gmail.com>
2008-02-11 16:46   ` Scott Cotton <scott.cotton@gmail.com>

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