[pgAdmin III] #257: UI glitch with superuser /canupdatecatalogs
От | pgAdmin Trac |
---|---|
Тема | [pgAdmin III] #257: UI glitch with superuser /canupdatecatalogs |
Дата | |
Msg-id | 056.f40facc27ea8e639d7fb0fde8de5d76a@code.pgadmin.org обсуждение исходный текст |
Ответы |
Re: [pgAdmin III] #257: UI glitch with superuser /canupdatecatalogs
|
Список | 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
В списке pgadmin-hackers по дате отправления: