From: Guillaume Lelarge <guillaume@lelarge.info>
To: Thorne, Francis <ft55@leicester.ac.uk>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: Where are security permissions stored ?
Date: Wed, 08 Jun 2011 20:46:38 +0200
Message-ID: <1307558799.2965.0.camel@laptop> (raw)
In-Reply-To: <3D30A33A5DA7F246A038659D03F9F2E20134FF8F0FBA@EXC-MBX3.cfs.le.ac.uk>
References: <3D30A33A5DA7F246A038659D03F9F2E20134FF8F0FBA@EXC-MBX3.cfs.le.ac.uk>
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.infohttp://www.dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, ft55@leicester.ac.uk
Subject: Re: Where are security permissions stored ?
In-Reply-To: <1307558799.2965.0.camel@laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox