Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-14 Thread Aren Cambre
That's not a bad practice when you typically have one non-admin application account per database. Using a role there just adds complexity. Complexity is bad. In this case, the remaining admin users can be a member of a special admin role or super users. Aren On Thu, Apr 14, 2011 at 7:54 AM, Dave

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-14 Thread Dave Page
On Thu, Apr 14, 2011 at 1:51 PM, Aren Cambre wrote: > Thanks. I still consider this a usability bug. Even in enterprise IT, it is > not uncommon to apply users directly to certain databases if there is only > one user account that will be used to access a database (besides admin > users, who are

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-14 Thread Aren Cambre
Thanks. I still consider this a usability bug. Even in enterprise IT, it is not uncommon to apply users directly to certain databases if there is only one user account that will be used to access a database (besides admin users, who are all probably members of a superadmin role). Also, given how Po

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-13 Thread Ashesh Vashi
Open File->Options. Go to Preferences tab and select "Show users for priviledges" and then Ok button. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi*

Re: [pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-13 Thread Aren Cambre
The Grant Wizard's *Privileges* tab only shows *public* in the dropdown. That dropdown shows nothing in the *Group Roles* or *Login Roles* section. By the way, below I meant that the dropdown on the *Privileges* tab isn't showing the roles. Aren On Wed, Apr 13, 2011 at 9:44 PM, Aren Cambre wrot

[pgadmin-support] Bug: Privileges tab doesn't show all roles

2011-04-13 Thread Aren Cambre
If I have a login role defined, the *Privileges *tab of the database properties dialog does not show that role. It only shows group roles. Also, searches on Google suggest that "login role" or "group role" are nonstandard terms. Aren