Ensure correct priviledges when creating tables in shared DB

This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the databases category.

Last Updated: 2024-04-25

When creating tables or views in shared databases for team members, you need to check that their users were given privileges

e.g.

GRANT ALL PRIVILEGES ON products TO manuel;

I ran into this issue with project M

Get list of all users with \du+