Skip site navigation (1) Skip section navigation (2)

Tree structure / access rights and associations

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-announce(at)postgresql(dot)org
Subject: Tree structure / access rights and associations
Date: 2006-11-23 12:41:15
Message-ID: 456596EB.1030100@fuzzy.cz (view raw or flat)
Thread:
Lists: pgsql-announce
Hello,

in an application I was working on recently, we had to develop a system 
to grant access rights on and associate items with parts of a tree. 
Imagine for example a tree of product categories in an e-shop - you 
might want to associate items with these categories with categories 
(once you associate the item to a category, it's associated to it's 
parent category too) and grant access rights on subtrees to 
administrators (once you grant access to a category, you're granting 
access to it's subcategories too).

Inspired by the solution we developed, I've implemented a similar system 
and I'm releasing it under GPL license. All the sources (basically a set 
of triggers) along with documentation etc. can be found here:

     http://www.fuzzy.cz/databaze/index-en.php

Tomas

Responses

pgsql-announce by date

Next:From: Marc G. FournierDate: 2006-11-23 23:52:15
Subject: news.postgresql.org back online ...
Previous:From: Josef SpringerDate: 2006-11-20 08:38:23
Subject: Version 2.70 of the BPM-/Workflowsystem OfficeTalk released

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group