12
Allow configuring `pgaudit.log_parameter`
Source: supabase/supabase#20183 · opened by @xEverth
pgaudit is the recommended method to log according to the docs:
It's possible to enable logging (for a session, or for specific roles) and to choose the log level:
I'd like to verify the call parameters of the RPCs called via postgREST, but I am not able to alter pgaudit.log_parameter due to a permission error:
> ERROR: permission denied to set parameter "pgaudit.log_parameter"
To Reproduce
Connect to the database as postgres or use the SQL Editor from the dashboard and run either of the following:
set pgaudit.log_parameter to 'on';
alter role authenticator set pgaudit.log_parameter to 'on';
Expected behavior
I expect to be able to set log_parameter and audit the parameters sent to the RPC.
Screenshots
 and to choose the log level:
I'd like to verify the call parameters of the RPCs called via postgREST, but I am not able to alter pgaudit.log_parameter due to a permission error:
> ERROR: permission denied to set parameter "pgaudit.log_parameter"
To Reproduce
Connect to the database as postgres or use the SQL Editor from the dashboard and run either of the following:
set pgaudit.log_parameter to 'on';
alter role authenticator set pgaudit.log_parameter to 'on';
Expected behavior
I expect to be able to set log_parameter and audit the parameters sent to the RPC.
Screenshots

1 vote · 0 comments
Extension for ChatGPT Response Streaming
2 votes · 0 comments
Support email signup universal link redirect
3 votes · 0 comments
Need guide/fix for configuring OPENAI_KEY in self-hosted supabase
2 votes · 0 comments
Force MFA enabled for all team members in Organization
9 votes · 0 comments
No comments yet.