Re: [GENERAL] Adding ACL notion to existing tables

2009-08-12 Thread Bruno Baguette
Le 08/08/09 02:13, Bruno Baguette a écrit : As you can see, I'm not really convinced for SOLUTION A or SOLUTION B as they have both some CONS. And they will both require some stored procedures to check references integrity. Solution B seems to be less weird to me. What would you do in that ki

[GENERAL] Adding ACL notion to existing tables

2009-08-07 Thread Bruno Baguette
Hello ! I would like known your appreciation, and to get some advices and tips about a design issue about adding ACL notion. I have several *existing* tables that manages some user's items which are quite different (postal adresses, photos, climbing_skills,...). Please note that "Users" are