Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e86HiQB86277 for ; Wed, 6 Sep 2000 13:44:26 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id KAA82559; Wed, 6 Sep 2000 10:44:18 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39B681E6.E5569FA@ipinc.com> Date: Wed, 06 Sep 2000 10:41:58 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: nicolas.michaud@philips.com CC: pgsql-sql@postgreSQL.org Subject: Re: Protection of tables by group and not by users References: <0056900011482454000002L042*@MHS> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/34 Hi there, I don't quite know what really want to do, however, postgres support group , so you can create a group one time, then grant or revoke this group of people from an object just need the group name. see CREATE GROUP groupname .... nicolas.michaud@philips.com wrote: > > Hello, > > Is it possible to protect a table of Postgresql by a group of persons instead of giving a list > of persons ? > > Thanks for your answers > > Regards > nicolas michaud -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com