From: Bruno Wolff III <bruno@wolff.to>
To: lexx@gorodok.net
Cc: pgsql-admin@postgresql.org
Subject: Re: database permissions:how to create read only user for db
Date: Sun, 26 Dec 2004 11:44:39 -0600
Message-ID: <20041226174439.GA12115@wolff.to> (raw)
In-Reply-To: <942074187.20041226134122@gorodok.net>
References: <1655106625.20041225155456@gorodok.net>
<20041225162007.GA28018@wolff.to>
<942074187.20041226134122@gorodok.net>
On Sun, Dec 26, 2004 at 13:41:22 +0600,
lexx@gorodok.net wrote:
>
> I see what you mean, but I want set access rights to database, not
> for database objects, I want to deny some users to create tables in
> database, but permit read values of existing tables.
There is a separate privilege for controlling creation of tables
(at least in recent versions - I am not sure about 7.1). By default
users will not have access to objects they didn't create (with a couple
of minor exceptions - see the documentation on GRANT).
> How to permit various access to tables I know, it's simlpy with `GRANT
> [..] ON TABLE ..', but I don't know how to deny creating new tables,
> and
> I think it's not possible with PostgreSQL, because as I can
> understand, GRANT don't support such ability for DATABASE.
It certainly is possible in recent versions.
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, lexx@gorodok.net
Subject: Re: database permissions:how to create read only user for db
In-Reply-To: <20041226174439.GA12115@wolff.to>
References: <1655106625.20041225155456@gorodok.net> <20041225162007.GA28018@wolff.to> <942074187.20041226134122@gorodok.net> <20041226174439.GA12115@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