Permission denied for table s1_scrape_series_added from stdin binary about promscale HOT 5 CLOSED

level=warn ts=2022-11-30T00:39:30.247Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:39:35.367Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:39:40.408Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:39:45.441Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_samples_scraped (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:39:50.504Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_samples_scraped (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:39:55.653Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_series_added (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:00.709Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:05.766Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:10.831Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_samples_scraped (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:15.879Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:20.916Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_duration_seconds (SQLSTATE 42501)" num_samples=45
level=warn ts=2022-11-30T00:40:25.957Z caller=write.go:244 msg="Error sending samples to remote storage" err="copier: writing series: error setting series_id: reading series id rows: ERROR: permission denied for table scrape_series_added (SQLSTATE 42501)" num_samples=45

SELECT proname,proowner::regrole
FROM pg_proc
WHERE pronamespace::regnamespace::text = '_prom_catalog'
  AND proname = 'create_ingest_temp_table';

SELECT r.rolname, r.rolsuper, r.rolinherit,
  r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
  r.rolconnlimit, r.rolvaliduntil,
  ARRAY(SELECT b.rolname
        FROM pg_catalog.pg_auth_members m
        JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
        WHERE m.member = r.oid) as memberof
, r.rolreplication
, r.rolbypassrls
FROM pg_catalog.pg_roles r
WHERE r.rolname !~ '^pg_'
ORDER BY 1;

      rolname      | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolconnlimit | rolvaliduntil |                                memberof                                | rolreplication | rolbypassrls 
-------------------+----------+------------+---------------+-------------+-------------+--------------+---------------+------------------------------------------------------------------------+----------------+--------------
 grafana_backend   | f        | t          | f             | f           | t           |           -1 |               | {}                                                                     | f              | f
 postgres          | t        | t          | t             | t           | t           |           -1 |               | {prom_reader,prom_writer,prom_modifier,prom_admin,prom_maintenance}    | t              | t
 prom_admin        | f        | t          | f             | f           | f           |           -1 |               | {prom_modifier,prom_maintenance}                                       | f              | f
 prom_maintenance  | f        | t          | f             | f           | f           |           -1 |               | {prom_reader}                                                          | f              | f
 prom_modifier     | f        | t          | f             | f           | f           |           -1 |               | {prom_writer}                                                          | f              | f
 prom_reader       | f        | t          | f             | f           | f           |           -1 |               | {}                                                                     | f              | f
 prom_writer       | f        | t          | f             | f           | f           |           -1 |               | {prom_reader}                                                          | f              | f
 promscale_backend | f        | t          | f             | f           | t           |           -1 |               | {pg_read_server_files,pg_write_server_files,pg_execute_server_program} | f              | f
 superuser         | t        | t          | f             | f           | t           |           -1 |               | {}                                                                     | f              | f