Ok, forgive my table structured background. I'm trying to see the light,
here, but I need help converting an SQL table based model into something
more CouchDB-ish. In an old-fashioned relational database it would look
similar to this: a users table and a permissions table.

Users:

Name    Group
-----------------
Alice   Developers
Bob     Developers
Carol   Developers
Eve     Managers
Frank   Managers

Permissions:

Group           Directory
---------------------
Developers      Source
Developers      Binary
Managers        Binary
Managers        Planning

Then I want to look up what directories Alice has permissions to, or
even make a master list of all the users and their permissions like:

Alice   Source
Alice   Binary
Bob     Source
Bob     Binary
...
Frank   Binary
Frank   Planning

I need to do the equivalent of adding and removing users, adding and
removing directories, and change group and permission assignments. None
of that can be static. 

So how do I set up my data and views in CouchDB to do this kind of
thing? Or is this just not the sort of thing CouchDB will be good at
modeling?

Thanks in advance for your help.


The contents of this e-mail are intended for the named addressee only. It 
contains information that may be confidential. Unless you are the named 
addressee or an authorized designee, you may not copy or use it, or disclose it 
to anyone else. If you received it in error please notify us immediately and 
then destroy it.

Reply via email to