look at http://code.google.com/p/spiff/ - SpiffGuard
On Apr 10, 11:36 am, "Kaali" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm designing a permission system to our messaging platform. The > platform has different channels which contains messages. Every > different user can have different permissions on a channel. The > permissions are create, modify, delete. > > With these permissions, we can define that some users can create > messages in a specific channel, and others can create, modify and > delete them, etc. > > How would you design a database for this, and how would you implement > it with SA? > > I'm thinking about making a many-to-many table which includes the > permissions, but i have no idea on how to implement this in SA. > > Database schema: > Channel = > - Id (integer) > - Title (unicode) > - Messages (many-to-many) > > Channel_Permissions = > - User Id (integer foreignkey) > - Channel Id (integer foreignkey) > - create (boolean) > - modify (boolean) > - delete (boolean) > > With simple many-to-many table, SA makes a Python list of the links. > Is there a way to get these extra boolean variables somehow and still > use the automatic list? > > Thanks and regards, > K --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---