I usually make
Usertable for User metadata
- Some of other tables have
userID(i.e. user specific)
- Some of others have
userIDor pivot table / m2m (i.e. shared between only some users)
- Others doesn't have
userIDat all (shared between all users)
But is this a good or even a secured way in the first place?
How does User management system work in this case; when there are thousands of similar users with very low privileges?