Better check & document required permissions

[HOSTED-POWER]

Hi,

We tried the check_postgres for example for checking long running queries (--action query_time). However when we didn't have enough permissions it just outputted:

POSTGRES_QUERY_TIME OK: DB "postgres" (host:127.0.0.1) longest query: 0s

Now with sufficient permissions it outputs:

POSTGRES_QUERY_TIME WARNING: DB "postgres" (host:127.0.0.1) longest query: 16s

I would expect the first one to simply output UNKNOWN because of lacking permissions :)

Atm we grant:

grant pg_read_all_settings, pg_read_all_stats, pg_stat_scan_tables to xxx;

I suppose this should be a bit better documented and for sure output error if it lacks permissions for certain actions.