> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 17 May 2006 15:07 > To: Dave Page > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Recursive SELECT problem > > "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.
Because I didn't realise they didn't inherit 'cos I missed the note at the bottom of the CREATE ROLE page :-) Thanks - that makes life significantly easier! Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
