'Permission denied for relation stl_load_errors on Redshift Serverless
I use Amazon Redshift Serverless and Query editor(v2) and I'm having trouble with user permissions. The following error occurred when importing data(.csv) in S3.
ERROR: Load into table 'x' failed. Check 'sys_load_error_detail' system table for details.
Therefore, I executed the command Select * From stl_load_errors to check the error, but it did not work well.
ERROR: permission denied for relation stl_load_errors
I checked my user permissions using select * from pg_user;and they are presented as follows.
However, I don't see any problem, what is the problem?
(I use hoge.)
| usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig |
|---|---|---|---|---|---|---|---|
| rdsdb | 1 | true | true | true | ******** | infinity | NULL |
| hoge | 101 | true | true | false | ******** | NULL | NULL |
I have tried to look at the query in the Amazon Redshift Serverless (Preview) dashboard under "Query and Database Monitoring", but could not find any details about the error.
What should I do?
amazon-web-services">
amazon-web-servicesamazon-s3">
amazon-s3amazon-redshiftamazon-iamamazon-redshift-serverless
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
