Unix Technical Forum

Re: RFC: roles

This is a discussion on Re: RFC: roles within the pgsql Interfaces Pgadmin Hackers forums, part of the PostgreSQL category; --> > -----Original Message----- > From: Andreas Pflug [mailto gadmin@pse-consulting.de] > Sent: 01 August 2005 14:56 > To: Dave Page ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Hackers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 05:27 PM
Dave Page
 
Posts: n/a
Default Re: RFC: roles



> -----Original Message-----
> From: Andreas Pflug [mailtogadmin@pse-consulting.de]
> Sent: 01 August 2005 14:56
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] RFC: roles
>
>
> So we have:
> - Groups/Roles and Users as object collection
> - Users will contain all roles with LOGIN
> - Groups/Roles the rest


Hmm, I'd only been thinking about the security tabs so far. I'd be
inclined to have just

Roles
-> Role 1
-> Role 2

in the treeview, and not try to make any distinction between 'users' and
'groups' at that level. The server doesn't, so we probably shouldn't
either. I suppose we could use a modified icon for those with LOGIN, for
convenience though, but I definately think there should be only Roles at
the top. (BTW, the icons for Roles/Role are already done, so just use a
placeholder for now).

Grouping as well as Icons could be used in the combo boxes, but even
then, I'm not sure grouping is required.

BTW, do you plan to keep the 'Display users as well as groups for
security' setting? I think we should, but obviously translated to mean
include LOGIN roles with other ROLES.

> - Both will use common dlgRole dialog, with different checkbox

settings for LOGIN

Yes.

> - NOLOGIN roles (in Groups/Roles) have the group icon
> - LOGIN roles without kids (pure users) have user icon
> - LOGIN roles with kids ('role-user') have group icon


See above :-)

> - Guru hint "bad practice" if a LOGIN role is used as role parent


Sounds good.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-17-2008, 05:27 PM
Andreas Pflug
 
Posts: n/a
Default Re: RFC: roles

Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: Andreas Pflug [mailtogadmin@pse-consulting.de]
>>Sent: 01 August 2005 14:56
>>To: Dave Page
>>Cc: pgadmin-hackers
>>Subject: Re: [pgadmin-hackers] RFC: roles
>>
>>
>>So we have:
>>- Groups/Roles and Users as object collection
>>- Users will contain all roles with LOGIN
>>- Groups/Roles the rest

>
>
> Hmm, I'd only been thinking about the security tabs so far. I'd be
> inclined to have just
>
> Roles
> -> Role 1
> -> Role 2
>
> in the treeview, and not try to make any distinction between 'users' and
> 'groups' at that level. The server doesn't, so we probably shouldn't
> either. I suppose we could use a modified icon for those with LOGIN, for
> convenience though, but I definately think there should be only Roles at
> the top.


I'm thinking different here, because you're using roles and users in
different situations.
When editing roles, you're planning the access scheme layout without
necessarily having certain persons in mind. After the app is installed,
you won't touch roles any more.
In contrast, adding users and assigning them existing roles is a
day-by-day business. That's why I'd like them separated.

(BTW, the icons for Roles/Role are already done, so just use a
> placeholder for now).


I don't see them in SVN... :-)

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:23 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com