Building the optimal user database model for your application (2015)

I'm curious what other people's approaches have been to modelling user/account relationships. What tradeoffs have you made? How do you manage permissions?