Обсуждение: [pgAdmin III] #315: Properties dialogue: REVOKE goes wrong in certain cases.

#315: Properties dialogue: REVOKE goes wrong in certain cases.
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  dpage  
     Type:  bug      |      Status:  new    
 Priority:  major    |   Milestone:         
Component:  pgadmin  |     Version:  trunk  
 Keywords:           |    Platform:  windows
---------------------+------------------------------------------------------
 Testcase to reproduce - execute as superuser postgres:

 CREATE ROLE blob;
 CREATE ROLE blob_read;
 CREATE TABLE test (t integer PRIMARY KEY);
 GRANT SELECT ON TABLE test TO blob_read;   -- note the underscore!
 GRANT SELECT ON TABLE test TO blob;   -- note how this role's name is
 identical up to the underscore! Note also, that this GRANT comes after the
 one before.

 Open properties dialog on table, chose "Privileges" rider.
 You see 3 users that have privileges:
     postgres arwdDxt
     blob_read    r
     blob    r

 Now try to delete "blob_read". (mark, click [Remove], click [OK]).
 !The wrong role gets deleted!

 Actually, that is what the server gets. All 3 commands are wrong /
 nonsensical!
     REVOKE ALL ON TABLE test FROM GROUP blob;
     GRANT SELECT ON TABLE test TO GROUP blob;
     REVOKE ALL ON TABLE test FROM GROUP blob;

 The bug only occurs if blob_read appears before blob in the list of
 privileges.
 I have tried to pin down this one for a while now, but it was extremely
 hard to pin down. Present in 1.12.2 as well as 1.12.3 (pre-release).

 Maybe underscores in role-names confuse the algorithm .. ?

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/315>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#315: Properties dialogue: REVOKE goes wrong in certain cases.
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  gleu    
     Type:  bug      |      Status:  assigned
 Priority:  major    |   Milestone:          
Component:  pgadmin  |     Version:  trunk   
 Keywords:           |    Platform:  windows 
---------------------+------------------------------------------------------
Changes (by gleu):

  * owner:  dpage => gleu
  * status:  new => assigned


--
Ticket URL: <http://code.pgadmin.org/trac/ticket/315#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#315: Properties dialogue: REVOKE goes wrong in certain cases.
----------------------+-----------------------------------------------------
  Reporter:  brsa     |       Owner:  gleu  
      Type:  bug      |      Status:  closed
  Priority:  major    |   Milestone:  1.12.4
 Component:  pgadmin  |     Version:  1.12  
Resolution:  fixed    |    Keywords:        
  Platform:  windows  |  
----------------------+-----------------------------------------------------
Changes (by gleu):

  * status:  assigned => closed
  * version:  trunk => 1.12
  * resolution:  => fixed
  * milestone:  => 1.12.4


Comment:

 Fixed in
 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=104bdc80488fc05f51335e4a5b8c7e5bb8c7ad51
 and
 http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=196e0a815d6e229455612aed2b92e3154c3ef645

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/315#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III