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

[pgAdmin III] #257: UI glitch with superuser /canupdatecatalogs

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #257: UI glitch with superuser /canupdatecatalogs
Date: 2010-10-15 22:21:24
Message-ID: 056.f40facc27ea8e639d7fb0fde8de5d76a@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#257: UI glitch with superuser /canupdatecatalogs
-----------------------------+----------------------------------------------
 Reporter:  Kasia Tuszynska  |       Owner:  gleu
     Type:  bug              |      Status:  new 
 Priority:  minor            |   Milestone:      
Component:  pgadmin          |     Version:  1.12
 Keywords:  role             |    Platform:  all 
-----------------------------+----------------------------------------------
 In pgAdminIII I checked off the box for: can inherit from parent role, can
 create db object, superuser

 Got the following sql:
 CREATE ROLE bob LOGIN
   ENCRYPTED PASSWORD 'md51e9484aace238e7cb2609130fd87646e'
   SUPERUSER INHERIT CREATEDB NOCREATEROLE;
 UPDATE pg_authid SET rolcapupdate=false WHERE rolname='bob';

 Than I created bobb
 In pgAdminIII I checked off the box for: can inherit from parent role, can
 create db object, superuser, Can modify catalog directly
 Got the following sql:
 CREATE ROLE bobb LOGIN
   ENCRYPTED PASSWORD 'md51e9484aace238e7cb2609130fd87646e'
   SUPERUSER INHERIT CREATEDB NOCREATEROLE;

 Conclusion:
 Sql level superuser = pgAdminIII superuser + can modify catalog directly

 This is misleading, I would call it a pgAdminIII bug but who knows maybe
 it is a feature...

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

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2010-10-15 22:22:21
Subject: pgAdmin III commit: Fix the setting of "Can update catalog" checkbox
Previous:From: pgAdmin TracDate: 2010-10-14 16:30:09
Subject: [pgAdmin III] #256: Add triggers on views support

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