Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 09188B5DBE7 for ; Wed, 8 Jun 2011 15:46:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 13735-06 for ; Wed, 8 Jun 2011 18:46:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 9F15EB5DBE4 for ; Wed, 8 Jun 2011 15:46:39 -0300 (ADT) Received: from [192.168.10.3] (ASte-Genev-Bois-153-1-51-237.w81-249.abo.wanadoo.fr [81.249.145.237]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 01C9D3B8F5; Wed, 8 Jun 2011 20:46:38 +0200 (CEST) Subject: Re: Where are security permissions stored ? From: Guillaume Lelarge To: "Thorne, Francis" Cc: "'pgsql-admin@postgresql.org'" Date: Wed, 08 Jun 2011 20:46:38 +0200 In-Reply-To: <3D30A33A5DA7F246A038659D03F9F2E20134FF8F0FBA@EXC-MBX3.cfs.le.ac.uk> References: <3D30A33A5DA7F246A038659D03F9F2E20134FF8F0FBA@EXC-MBX3.cfs.le.ac.uk> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.0.2 (3.0.2-1.fc15) Content-Transfer-Encoding: 8bit Message-ID: <1307558799.2965.0.camel@laptop> Mime-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/44 X-Sequence-Number: 37670 On Wed, 2011-06-08 at 11:36 +0100, Thorne, Francis wrote: > In postgres 8.3.6 could you please tell me where the security > permission details for users are stored (i.e. who has select on a > particular table) Column relacl in the pg_class table of the pg_catalog schema. > , for example in the master database in M-SQL, am I right in thinking > these details are stored in pg_catalog and if so I’m guessing this > should be backed up > pg_dump takes care of this for all the objects you dump. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com