PLPGSQL 'SET SESSION ROLE' problems .. - Mailing list pgsql-general

From Greg Wickham
Subject PLPGSQL 'SET SESSION ROLE' problems ..
Date
Msg-id 964C943783CDCE4BBA0CE327AA8E7BA5C2802D@vm-a-ex1.ms.aarnet.edu.au
Whole thread Raw
List pgsql-general
Hi,

Is it possible to change the current role to another arbitrary role
using a PLPGSQL function?

In essence I've a function "authorise" created by the db superuser with
'SECURITY DEFINER' specificied.

However from within plpgsql the 'superuser' attribute isn't honored when
trying to change roles (ie: the non 'superuser' rules for role change
must be honoured).

Is this a bug?

tnx,

   -greg

--

pgsql-general by date:

Previous
From: pgsql.gen@tuxbeagle.com
Date:
Subject: Using C API
Next
From: vladimir konrad
Date:
Subject: Re: corrupt database?