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 Page
<dpage@pgadmin.org> wrote:
On Thu, Apr 14, 2011 at 1:51 PM, Aren Cambre
<aren@arencambre.com> 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 all probably members of a superadmin role).
Maybe, but that doesn't mean that our default configuration should aid such bad practice.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company