Re: [SQL] High level discussion for design of using ACL to retrieve Data

2005-11-11 Thread Joel Fradkin
ldistrict.districtid;   Any ideas would be great!       Joel Fradkin     -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joel Fradkin Sent: Thursday, November 10, 2005 3:19 PM To: pgsql-sql@postgresql.org Subject: [SQL] High level discussion for des

[SQL] High level discussion for design of using ACL to retrieve Data

2005-11-10 Thread Joel Fradkin
We currently use a system with 4 tables (division, region, district, location). The data for the most part has a field named location id. The users get a level and location id (if they are district it would represent a district id etc).   I have been asked to make this more flexible, fo