What’s your idea?
Not sure if there’s another way to go about this, but I noticed that whenever I add new tables, all of the roles default to having permissions to read/update/delete everything on that table.
I am not sure what’s the best way to go about this, but two possible ideas are:
- Add an option to specify what the permissions of each role defaults to for new tables (in the app services tab when clicking on a role and looking at permissions)
- Add a way to specify which roles have permissions to read/update/delete that table when creating it (in the data tab when creating a new table)
I personally prefer the second option, but would love to get some thoughts on this.
What problem might it solve?
Currently, if I create a table but only want some roles to have access to it, I have to remember to manually edit permissions of those roles to remove access. This could easily create security vulnerabilities/inconsistencies, so it would be great to solve this in a way that doesn’t solely rely on memory.