On 10/21/21 08:39, Toomas wrote:
Hi,
Basically the case was, when *session_user != current_user* then command
\password failed with error message “ERROR: permission denied”. All was
good when session_user == current_user.
In terms of statement “session_user user was set as the owner of the
database automatically” - I have a setup where session_user is changed
automatically as database owner when user logs into database.
What I am looking for is a step by step outline that approximates:
1) psql -U <some_user>
2) The command(s) that set session_user as database owner.
3) The command(s) that make session_user != current_user.
4) Output of:
select session_user, current_user;
5) The output of \du for the users involved
BR,
Toomas
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
