From: | "A Lau" <lau(dot)studium(at)gmx(dot)net> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | GRANT ALL ON recursive for all tables in my scheme? |
Date: | 2008-03-04 20:14:50 |
Message-ID: | 000f01c87e34$6b981fb0$0264a8c0@foxy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oisin Glynn | 2008-03-04 20:45:51 | Re: [GENERAL] Documenting a DB schema |
Previous Message | Shahaf Abileah | 2008-03-04 20:02:27 | Documenting a DB schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Kristina Yamamoto | 2008-03-04 20:20:47 | Question about PostgreSQL's bytea compatibility with MS Access as front-end |
Previous Message | Shahaf Abileah | 2008-03-04 20:02:27 | Documenting a DB schema |