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
Attachments:
describe_role_login.patchtext/x-diff; charset=us-ascii; name=describe_role_login.patchDownload+2-0
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.--
ThanksBernd
[ Attachment, skipping... ]
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
--
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.--
ThanksBernd
[ Attachment, skipping... ]
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +