* Denish Patel (denish@xxxxxxxxxx) wrote: > you should be able to use secure_check_postgres method to avoid granting > SUPER permission on monitoring user. [...] Denish, Please see my reply to Payal. This doesn't work. At the very least, the permissions on the pg_stat_repl() function need to be adjusted to be only GRANT'd to the monitoring user, otherwise the information is available to everyone. If that's the intent, then the view might as well be granted to PUBLIC. Recall that, by defualt, EXECUTE on a function is granted to PUBLIC. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
