Re: Proposed Patchs

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Thomas Sondag
> Sent: 24 May 2006 17:28
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Proposed Patchs
>
> Hi,
>
> With PostgreSQL 8.1 and new ROLE object remplacing traditional
> USER/GROUP, I was a bit confuse using the dlgProperty and
> dlgSecurityProperty dialog because I can only select USER (ROLE with
> LOGIN privilege) for owner and GROUP (ROLE without LOGIN privilege)
> for privileges .
> And I not sure this comportment can match all PostgreSQL 8.1 usages
> scenarios (like one of my case).
>
> This proposed patch :
> - change owner and privilege list to get the full ROLE list.

How is this different from the current behaviour if the Show Users for
Privileges option is turned on? The whole point there is to promote the
use of group based permissions rather than user based for both
simplicity (because the list only shows the groups), and for cleanliness
of design (users come and go, groups tend to be more permanent). In 8.1+
of course, we simply replace users and groups with roles with or without
the login flag.

> - select by default currently connected ROLE in the owner list
> (replacing the blank filed) for new object creation

OK.

> - remove pg_global in the available tablespace list

Probably a good idea, yes.

> - select current user default tablespace in tablespace list
> (replacing the blank filed, yes I don't like blank field) for new
> object creation

OK.

Regards, Dave.