Search Postgresql Archives

Re: current_role of caller of a DEFINER function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: current_role of caller of a DEFINER function
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 26 Jun 2024 05:42:21 -0700
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAFCRh--0j77ueun+Ak0vRe_vi__Jks_HZjD9QbD+THR8gAWvRQ@mail.gmail.com>
References: <CAFCRh--0j77ueun+Ak0vRe_vi__Jks_HZjD9QbD+THR8gAWvRQ@mail.gmail.com>

On Wednesday, June 26, 2024, Dominique Devienne <ddevienne@xxxxxxxxx> wrote:

Only session_user
is representative of the caller, and reliable (modulo SUPERUSER and
SET AUTHORIZATION, but that's a different story and kinda normal)

Why can you not use session_user then?

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: current_role of caller of a DEFINER function
  - From: Dominique Devienne
- Re: current_role of caller of a DEFINER function
  - From: Isaac Morland

References:
- current_role of caller of a DEFINER function
  - From: Dominique Devienne

Prev by Date: Re: current_role of caller of a DEFINER function
Next by Date: Re: current_role of caller of a DEFINER function
Previous by thread: Re: current_role of caller of a DEFINER function
Next by thread: Re: current_role of caller of a DEFINER function
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux