Thank you Tom! It turns out that the Oracle way of doing things (SECURITY DEFINER) was the wrong way here. Thanks a bunch.

On 8/12/21 4:37 PM, Tom Lane wrote:
ctually, for that specific requirement, there's an easier way:

        ALTER USER target_user SET log_statement = 'all';

While the target_user can't do that for himself, a superuser
can.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com



Reply via email to