| Lists: | pgsql-patches |
|---|
| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Show login privilege in psql \du command |
| Date: | 2007-09-18 11:50:37 |
| Message-ID: | 7A00EB4736851DA30374BC34@imhotep.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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 | Content-Type | Size |
|---|---|---|
| describe_role_login.patch | text/x-diff | 1.1 KB |
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Show login privilege in psql \du command |
| Date: | 2007-11-01 22:39:50 |
| Message-ID: | 200711012239.lA1MdoV11700@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Show login privilege in psql \du command |
| Date: | 2008-04-02 12:35:30 |
| Message-ID: | 200804021235.m32CZUY17763@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-patches |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +