On Mon, Aug 17, 2020 at 5:46 PM David Gauthier <davegauthierpg@xxxxxxxxx> 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.
