How to fix have SQL Error [42501]: ERROR: permission denied for relation

Asked May 31 '23 at 05:43

Active May 31 '23 at 05:47

Viewed 197 times

I try to run query and got this error message

SQL Error [42501]: ERROR: permission denied for relation name_field db in redshift

here full details error

already try run this GRANT ALL PRIVILEGES ON TABLE name_field TO nameuser; following this reference Permission denied for relation

asked May 31 '23 at 05:43

serotoninpill

Please provide enough code so others can better understand or reproduce the problem. – Community May 31 '23 at 08:22
I'm guessing the user you're using may be in a group that has an explicit REVOKE on it that is overriding the grant. – dfundako May 31 '23 at 19:06

0 Answers0