From: Bruno Wolff III <bruno@wolff.to>
To: juanmime@ono.com
Cc: pgsql-admin@postgresql.org
Subject: Re: How to deny remote backups ?
Date: Fri, 4 Mar 2005 11:45:35 -0600
Message-ID: <20050304174535.GA25380@wolff.to> (raw)
In-Reply-To: <4208B84C0001250D@resmta04.ono.com>
References: <4208B84C0001250D@resmta04.ono.com>
On Fri, Mar 04, 2005 at 17:33:02 +0100,
juanmime@ono.com wrote:
>
> OK. but I think that an aproximation to the solution or a half solution could
> be deny the user consulting the system database catalog or (pg_tables). In
> that case, the user is not able to know the name of the tables inside the
> db, and therefore he does not know which are the tables to dump. I think
> also, that pg_dump could fail at this scenario.
> 1. What do you think about this ?
I don't think it is a good idea. Since you are worried about this, I am going
to guess that the users are running a client (such as psql) to do their
inserts and deletes. If so, they are going to be able to find out the
table names. If this isn't the case and everything is being done by
an application running on the server, then you should be having that
application control access.
> 2. Is it possible (deny the access to the system catalog or tables (like
> pg_tables) to a certain user ?
You will break things if you prevent people from reading the system catalogs.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, juanmime@ono.com
Subject: Re: How to deny remote backups ?
In-Reply-To: <20050304174535.GA25380@wolff.to>
References: <4208B84C0001250D@resmta04.ono.com> <20050304174535.GA25380@wolff.to>
* 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