Looking at that django link, rather than creating a new role for every user ID, you can set a value in each transaction that can contain whatever you like, incl

Looking at that django link, rather than creating a new role for every user ID, you can set a value in each transaction that can contain whatever you like, including a user ID [1] [2]. What I don't like about that django solution is that it's very django dependent. If you ever had another system that can create users, the django signal wouldn't fire and the new role wouldn't be created. Apart from that, you'll have a lot of unnecessary roles in postgres itself. [1] https://news.ycombinator.com/item?id=30706295 https://news.ycombinator.com/item?id=30706295 [2] https://news.ycombinator.com/item?id=30703881 https://news.ycombinator.com/item?id=30703881