Clemens Schwaighofer wrote:
The other problem is, that there is no "grant all on table db.* ..." but
I have to do that for each table seperate, or in a "grant all on table
a, b, ...".
I am not sure if there is an easier way, except perhaps through a select
from the pg_ catalog for this db and get the table names there ...
I believe there are some scripts that can help..
http://pgedit.com/public/sql/acl_admin/index.html
http://unf.be/postgresql/postgres_grant_all.perl
http://www.archonet.com/pgdocs/grant-all.html
one or more of those URLs may help. FYI, I got these from the infobot
on the freenode #PostgreSQL IRC channel
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
