[PostgreSQL] Check table permissions when ERROR: permission denied for ~ error occurs
Tadashi Shigeoka · Mon, March 5, 2012
In PostgreSQL, when you encounter an error like ERROR: permission denied for ~, it means you don’t have permissions for the table, so you need to check this.
Error Details
ERROR: permission denied for table table_name
Command to Check Permissions
\\z
Query to Grant Table Permissions
GRANT SELECT, UPDATE, INSERT ON table_name TO role_name;
That’s all from the Gemba.