From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Page <dpage@vale-housing.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Recursive SELECT problem
Date: Wed, 17 May 2006 10:06:42 -0400
Message-ID: <19519.1147874802@sss.pgh.pa.us> (raw)
In-Reply-To: <E7F85A1B5FF8D44C8A1AF6885BC9A0E40138824D@ratbert.vale-housing.co.uk>
References: <E7F85A1B5FF8D44C8A1AF6885BC9A0E40138824D@ratbert.vale-housing.co.uk>
"Dave Page" <dpage@vale-housing.co.uk> writes:
> I'm trying to write a query to determine whether or not the current
> login role has CREATEDB (or CREATEROLE) privileges, either directly or
> inherited from a parent role.
Those privileges don't inherit, so I'm not sure why you need a recursive
check.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, dpage@vale-housing.co.uk
Subject: Re: Recursive SELECT problem
In-Reply-To: <19519.1147874802@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox