Re: passing linux user to PG server as a variable ?

On Mon, Aug 17, 2020 at 5:46 PM David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:

> Users will connect to the DB and then update a table using SQL at the
> prompt. And I want a post update trigger to identify who (linux user on
> the client side) just made that change. I was sort of hoping that this 8
> character string (the linux user id) could be passed from client -> server
> as a parameter that is set on the user/client side, perhaps using that "-v"
> option, which could somehow be passed along to the server.
>

If you are giving a user a direct connection to the DB so they can run SQL
they should have their own individual credentials.

Regardless, if you rely on runtime variables there is no way to prevent the
value of those variables from being changed by the user.

David J.