pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (5+ messages)

Message-ID: <20041226174439.GA12115@wolff.to>
Permalink:  ../20041226174439.GA12115@wolff.to/
Also on:    postgresql.org/message-id/20041226174439.GA12115@wolff.to

 · 

reply

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