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 f3JBNHu71964 for ; Thu, 19 Apr 2001 07:23:18 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 7C95E2AB22; Thu, 19 Apr 2001 08:24:01 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: "Richard Huxton" , Subject: Re: groups in postgres Date: Thu, 19 Apr 2001 08:24:00 +0300 X-Mailer: KMail [version 1.2] References: <20010419081218.CA9D42A3A7@mainbox.archonet.com> In-Reply-To: <20010419081218.CA9D42A3A7@mainbox.archonet.com> MIME-Version: 1.0 Message-Id: <01041908240000.12665@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/323 X-Sequence-Number: 2679 On Jue 19 Abr 2001 11:12, Richard Huxton wrote: > Martín Marqués said: > > 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. > > Sounds like you want different groups for different users, and a view for > each group. You can then define rules for each view defining the access > that is available. They're gonna be groups of users, which will be loading data related to there group. I don't want the users from one group to load data related to other groups. And there is going to be a super-group that can change anything. I'm not sure about the views and rules. Never used them. I'll check it out. ;-) 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 -----------------------------------------------------------------