Re: Invoking user of the function with SECURITY DEFINER

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: Madan Kumar <madankumar1993(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Invoking user of the function with SECURITY DEFINER
Date: 2019-04-10 15:19:53
Message-ID: C6248F54-6FD3-4DC4-9031-38C73493B1A9@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Looked like a bug.

> 25 нояб. 2018 г., в 14:50, Madan Kumar <madankumar1993(at)gmail(dot)com> написал(а):
>
> Got it..
> In my case i was getting session_user in declare section and trying to validate later which always resulted in the function owner.
> DECLARE
> user text := SESSION_USER;
>
> So using it within the BEGIN; ...; END; clause worked for me.
> Thanks.
>
>
> Warm Regards,
> Madan Kumar K
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sherrylyn Branchaw 2019-04-10 15:50:30 Re: Does pg_stat_get_live_tuples() matter?
Previous Message Олег Самойлов 2019-04-10 15:07:21 Re: New timeline when starting with a restored data dir