Yes you can, but you have to make one more table. From first table where you turn on option User can see and edit own data you can use table name from option MySQL table name for editing which you can find on Editing tab in table settings.

Then make another table from MySQL query like this:

SELECT * FROM table_name_for_editing

Instead of table_name_for_editing you will use table name from option MySQL table name for editing. Like this will be shown all data from all users.