Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6B63F9FBB1B; Tue, 7 Aug 2007 10:41:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07883-03; Tue, 7 Aug 2007 10:41:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sr06-03.mta.terra.com.br (sr06-03.mta.terra.com.br [200.154.152.72]) by postgresql.org (Postfix) with ESMTP id EBF599FB900; Tue, 7 Aug 2007 10:41:31 -0300 (ADT) Received: from tiaro.hst.terra.com.br (tiaro.hst.terra.com.br [200.176.10.7]) by burta.hst.terra.com.br (Postfix) with ESMTP id 94C453A68078; Tue, 7 Aug 2007 10:41:29 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: e3ae213d8f8e993b3f40362cb0688993 Received-SPF: pass (tiaro.hst.terra.com.br: domain of terra.com.br designates 200.176.10.7 as permitted sender) client-ip=200.176.10.7; envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72]; Received: from [172.16.2.72] (200-162-219-207.corp.ajato.com.br [200.162.219.207]) (authenticated user ranieri.oliveira) by tiaro.hst.terra.com.br (Postfix) with ESMTP id 4B31C2141EB; Tue, 7 Aug 2007 10:41:29 -0300 (BRT) Message-ID: <46B8766F.7050107@terra.com.br> Date: Tue, 07 Aug 2007 10:41:03 -0300 From: Ranieri Mazili User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Restricting columns by users Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.613 tagged_above=0 required=5 tests=AWL=0.612, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200708/346 X-Sequence-Number: 118195 Hello, I'm looking for a method to restrict columns by users on postgresql, searching in google I found what I want, but in mysql, below I reproduce the paragraph that shows what I exactly want: "MySQL can also restrict access on the table level and even on the column level. What this means is that a user can have zero privileges on a database, but can have all privileges on a table in that database. Alternatively, a user can have zero privileges on a database, restricted privileges on a table, and all privileges on any particular column on that table. This is done by inserting records into the TABLE_PRIV table and the COLUMN_PRIV table." Exist something like it for postgresql? Thanks