Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql security checks - Mailing list pgsql-novice

From Josh Kupershmidt
Subject Re: Postgresql security checks
Date
Msg-id AANLkTi=u6M2a7bn8sO0ZtqUZ0rj_P8Urx=ei3K9nGZ5j@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql security checks  (Thom Brown <thom@linux.com>)
List pgsql-novice
Tree view 
On Wed, Sep 1, 2010 at 11:32 AM, Thom Brown <thom@linux.com> wrote:
> Yes, I had discovered this previously but obviously I've got a memory
> leak.  Actually, doesn't this apply to roles too?

Yeah, pg_shadow is just a view on top of pg_authid, declared as:

 SELECT ...
   FROM pg_authid
   WHERE pg_authid.rolcanlogin;

So I think either query would work, with pg_shadow only showing you
roles which have login enabled.

Josh

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Postgresql security checks
Next
From: "Turner, John J"
Date:
Subject: Installing temporal "period" data type and support functions