Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3ILJhu88153 for ; Wed, 18 Apr 2001 17:19:43 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 569F32AB22; Wed, 18 Apr 2001 18:20:20 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql-sql@postgresql.org Subject: groups in postgres Date: Wed, 18 Apr 2001 18:20:18 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01041818201806.04332@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/317 X-Sequence-Number: 2673 I building an application that will load data on a database by lots of people. So I thought about putting them in a group and giving priviledges to the group. The problem is the the information on the main table is related with fields of other tables, and depending on how it's related, I want some users to be able to modify the data and I don't want those users to insert new data if the relation is right for them. Am I clear up to know? Now, how can I do this? Is it posible manipulating groups? Or do I have to play with triggers. Saludos... :-) -- El mejor sistema operativo es aquel que te da de comer. Cuida tu dieta. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------