| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Murillo corvino rocha <murillo_corvinorocha(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: session_user different from current_user after normal login |
| Date: | 2022-11-17 17:35:55 |
| Message-ID: | 359ae842-c217-1055-e24b-173918c1e5f3@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/17/22 07:11, Murillo corvino rocha wrote:
> Hi,
>
> We have a situation where two users are members of a group, like below:
>
> Following the solution in the discussion above, we solved our problem
> using the command:
>
> SET SESSION AUTHORIZATION <username>;
>
> For our example:
>
> SET SESSION AUTHORIZATION user1;
>
> After that, it was possible to change the user password.
>
> My question is: is that a normal behavior? should I, after a normal
> loggin, be logged as
>
> group_read_only as my current_user?
Something or someone is doing SET ROLE group_read_only.
>
> Thanks in advance.
>
> Murillo.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Вадим Самохин | 2022-11-17 17:42:21 | Re: Postgresql 11.3 doesn't use gist index on polygon column |
| Previous Message | Tom Lane | 2022-11-17 15:52:56 | Re: Postgresql 11.3 doesn't use gist index on polygon column |