nice and easy question since it is mostly what I am doing now 🙂
I would not have said that some time ago: I deleted a row in a view and discovered that the row in the parent table has been deleted too!!!! :crazy: I always tought that a view "is a view", not that it could be an "interface" with a table!!!
Since then, I put only "SELECT" permission on the views to make sure that nobody messed up with the data base without knowing it!
Thanks for the question!