pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: A Lau <lau.studium@gmx.net>
To: pgsql-admin@postgresql.org
To: pgsql-general@postgresql.org
Subject: GRANT ALL ON  recursive for all tables in my scheme?
Date: Tue, 4 Mar 2008 21:14:50 +0100
Message-ID: <000f01c87e34$6b981fb0$0264a8c0@foxy> (raw)

I recently searched for a way to grant permissions to a new created user for
all tables in a scheme or database. I just found ways who uses psql and
scripts. But I'm astonished that there is no way to do it with the "grant
all on database [schema]..."-option. Actually i thought that a grant on a
schema or database would recusivly set the accoding permissions to the
corresponding objects (eg. tables, views...). Is there a way to do it easily
in SQL-Syntax without psql and scripting? Why it can't be done with the
grant-operator?
 
thanks for help.
 
Andreas




view thread (3+ messages)  latest in thread

Message-ID: <000f01c87e34$6b981fb0$0264a8c0@foxy>
Permalink:  ../000f01c87e34$6b981fb0$0264a8c0@foxy/
Also on:    postgresql.org/message-id/000f01c87e34$6b981fb0$0264a8c0@foxy

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: lau.studium@gmx.net, pgsql-general@postgresql.org
  Subject: Re: GRANT ALL ON  recursive for all tables in my scheme?
  In-Reply-To: <000f01c87e34$6b981fb0$0264a8c0@foxy>

* 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