I am unable to see entries for table timescaledb_information.job_errors for users that are not the owner.
The other users have select rights on the table:
| schema_name | role_name | has_usage_privilege | has_create_privilege |
|---|---|---|---|
| timescaledb_information | pguser1 | true | true |
| timescaledb_information | pguser2 | true | false |
| timescaledb_information | pguser3 | true | true |
Only the pguser1 is able to see the entries for the table for some reason, the others only see an empty table.
I am use timescaledb v.2.17.0
Select for pguser1:
| job_id | proc_schema | proc_name | pid | start_time | finish_time |
|---|---|---|---|---|---|
| 1075 | public | totalrecords | 3958695 | 2024-12-30 15:30:04.571 +0100 | 2024-12-30 15:30:04.585 +0100 |
Select for pguser2 and pguser3 table is empty.