Thread: Show login privilege in psql \du command
Please find attached a tiny patch which adds a "Login" field to the \du
command, displaying wether a role has the LOGIN privilege granted or not. I
found this useful, since you have to query the system catalog directly to
find out which role is permitted to login.
--
Thanks
Bernd
Attachment
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---------------------------------------------------------------------------
Bernd Helmle wrote:
> Please find attached a tiny patch which adds a "Login" field to the \du
> command, displaying wether a role has the LOGIN privilege granted or not. I
> found this useful, since you have to query the system catalog directly to
> find out which role is permitted to login.
>
> --
> Thanks
>
> Bernd
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
This feature is being added by another patch so this patch is no longer needed --- See the INHERIT \du thread. --------------------------------------------------------------------------- Bernd Helmle wrote: > Please find attached a tiny patch which adds a "Login" field to the \du > command, displaying wether a role has the LOGIN privilege granted or not. I > found this useful, since you have to query the system catalog directly to > find out which role is permitted to login. > > -- > Thanks > > Bernd [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +