X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D11DD528F7 for ; Mon, 20 Jun 2005 15:49:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17132-09 for ; Mon, 20 Jun 2005 18:49:18 +0000 (GMT) Received: from gateway.wintersgift.com (unknown [209.121.79.85]) by svr1.postgresql.org (Postfix) with ESMTP id 26E35528E0 for ; Mon, 20 Jun 2005 15:49:17 -0300 (ADT) Received: from [10.0.0.19] (66-224-215-74.atgi.net [66.224.215.74]) by gateway.wintersgift.com (Postfix) with ESMTP id 14604166A02 for ; Mon, 20 Jun 2005 11:49:16 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v622) Content-Transfer-Encoding: 7bit Message-Id: <70756f4668fbcef8a75a240af4bb3d7d@wintersgift.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-interfaces@postgresql.org From: Teunis Peters Subject: users, address record restrictions Date: Mon, 20 Jun 2005 11:51:11 -0700 X-Mailer: Apple Mail (2.622) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/55 X-Sequence-Number: 5623 I've got an interesting problem - this MIGHT (probably) isn't the right forum for this. however - I'd like to restrict access to specific records and groups of records (based on another table) - and I'm not even sure where to start looking. I suspect I actually need to look into triggers and/or embedded libraries to solve this (and this means writing it) but I haven't figured where to start... basically per-record (given a set of rules) access restrictions. Please do let me know where I can ask more :) Ta! - Teunis Peters