I'm getting this error when making a request using...
# help
l
I'm getting this error when making a request using postgrest
{'message': 'permission denied for table clients', 'code': '42501', 'details': None, 'hint': None}
I have tried putting and removing the RLS to the table, and it keeps the error. It seems to be a postgres level permissions error, is there a way to reset to default permission settings?
n
Hello @leynier! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
🆕 permission denied for tables error
g
Anything special about the environment? Prisma? Was the table created in the UI? RLS turned off will ignore any policies you have, but on a select should return an empty array if no permission on the row. What is the request? Public schema? Any changes to that? Check grants on the table for anon and authenticated.
n
permission denied for tables error