I tried to do something similar but hit the problem that not only does each table have a unique ID, so does every field. Much bigger problem than you expect.
I was lucky in that I’d been using views, so just a case of modifying the view. If you’re using tables, you could try creating a view in a different schema, then restricting the rights of the user account. That depends upon your database though.
1 Like