Обсуждение: 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
Вложения
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. +