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
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