How is the owner of a row defined so that when you set data permissions to “Own records” they can access? I assume it is the person who created the record. Can we update this if we wanted the owner to be someone other than who created it, e.g. allow a manager to create an item for someone else but then they get access.
I’m assuming for personal data I do need to lock the access down via data permissions. If a user for example had access to view all records in a table I understand that they would be able to manually use the API to view other peoples rows even if the app didn’t have a page which allowed them to?
As a sneaky extra question is there any way to just view all the data in a collection? I’ve probably created some junk data in some of my collections which the UI won’t be showing. Do I have to create a page that shows it all so I can delete it or is there a built in way to see and manage all rows somewhere?
Thank you, if that’s the way to do it I’ll use a relation to a user and add a data scope.
For my second question I assume there is no default way to view all the data in a collection for management without adding a data block manually? Is it a bad idea to connect to the “main” database with normal database management tools to check and modify data?
Creating a temporary page or data block is the safest and recommended approach. Directly manipulating the database is possible but carries significant risks and should be done with caution.
