Re: Invoking user of the function with SECURITY DEFINER - Mailing list pgsql-general

From Олег Самойлов
Subject Re: Invoking user of the function with SECURITY DEFINER
Date
Msg-id C6248F54-6FD3-4DC4-9031-38C73493B1A9@ya.ru
Whole thread Raw
In response to Re: Invoking user of the function with SECURITY DEFINER  (Madan Kumar <madankumar1993@gmail.com>)
List pgsql-general
Looked like a bug.

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




pgsql-general by date:

Previous
From: Олег Самойлов
Date:
Subject: Re: New timeline when starting with a restored data dir
Next
From: Sherrylyn Branchaw
Date:
Subject: Re: Does pg_stat_get_live_tuples() matter?