Re: Users and groups - Mailing list pgsql-admin

From Raj Mathur
Subject Re: Users and groups
Date
Msg-id 15948.62980.757323.308651@mail.linux-delhi.org
Whole thread Raw
In response to Re: Users and groups  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

    Tom> Raj Mathur <raju@linux-delhi.org> writes:
    >> ...  However, the complementary process, determining all the
    >> users in group administrators, isn't so clean.

    Tom> Doesn't select grolist from pg_group where groname =
    Tom> 'administrators' do it for you?  I suppose you might want the
    Tom> thing to map sysids back to usernames ...

Ah, maybe I should have been more explicit: need a list of usename's
of users who are admins.  Any simple command (set) to do that?

Regards,

-- Raju
--
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/
                      It is the mind that moves

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Auth users and command pg_passwd
Next
From: Andreas Schmitz
Date:
Subject: Still a bug in the VACUUM ??? !!!