Sample Header Ad - 728x90

readonly user on PostgreSQL 14 let me create new tables, why?

-1 votes
2 answers
362 views
I try to apply any of these to create read_only_user: - https://docs.snaplet.dev/guides/postgresql - https://www.commandprompt.com/education/how-to-create-a-read-only-user-in-postgresql/#:~:text=Conclusion-,To%20create%20a%20read%2Donly%20user%20in%20the%20PostgreSQL%20database,schema%2C%20and%20tables%20in%20it . - https://www.keyvanfatehi.com/2021/07/14/how-to-create-read-only-user-in-postgresql/ In all cases, the new read_only_user is able to create a new table in my Database (here: MicroReseau) where I want to prevent that. **Why the read_only_user can create new tables and how to prevent that?** Additional info: enter image description here
Asked by Eric Ouellet (101 rep)
Nov 2, 2023, 06:38 PM
Last activity: Nov 3, 2023, 01:38 PM