Which RDBMS? If Pg, I’d suggest using row-level ACLs directly in the database rather than pushing the ACL logic into the ORM/app code.
> On Jan 3, 2018, at 12:37 , Aaron Trevena <aaron.trev...@gmail.com> wrote: > > Hi All, > > I was wondering if anyone can share any success, tips and problems of > using dbix-class in a multi-tenant application. > > I'm looking at using tenant id in the main tables, and thinking best > approach will be to add logic to a resultset base class or role to > hook in forcing queries to restrict by tenant id, but would really > like to hear what anybody who's done this stuff already did and what > worked or not and any gotchas, > > Thanks, > > A. > > -- > Aaron J Trevena, BSc Hons > http://www.aarontrevena.co.uk > LAMP System Integration, Development and Consulting > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk