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

Bug in pgadmin III regarding privileges.

From: Michalis Kabrianis <mk(at)interzone(dot)gr>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug in pgadmin III regarding privileges.
Date: 2003-12-02 07:35:35
Message-ID: 3FCC40C7.8000700@interzone.gr (view raw or flat)
Thread:
Lists: pgadmin-support
Hi
I think I found a bug regarding privileges in pgadmin III
To replicate:
create a user in postgres named "arwdxt" (not all letters needed of 
course :)
Create another user named temp_user
as user "arwdxt" create a table test_table
REVOKE all ON test_table FROM temp_user
GRANT SELECT ON test_table TO temp_user

Now, if you check the privileges on that table, you'll see that user 
temp_user seems to have all the privileges..

The reason is the name of the user who granted the rights (and the way 
it's presented by postgres and searched by pgadmin), in our case it 
would be :

temp_user=r/arwdrxt

Regards
Michalis Kabrianis





Responses

pgadmin-support by date

Next:From: GuineaPigDate: 2003-12-02 08:07:47
Subject: Re: SuSE 9.0/pgadmin3
Previous:From: Adam H.PendletonDate: 2003-12-02 05:48:37
Subject: Re: porting for redhat 8.0

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