Postgresql readonly role and user Postgresql readonly role and user postgresql postgresql

Postgresql readonly role and user


It is likely that the table you're querying from, customer_search_query is not in the public schema. Try running this command.

GRANT SELECT ON customer_search_query TO readonly;