Horton

Re: [SQL] Permissons on database

Roland Roberts <roland@astrofoto.org>

View thread View on postgr.es
From: Roland Roberts <roland@astrofoto.org>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Date: 2001-03-07T20:40:44Z
Lists: pgsql-general 
>>>>> "bk" == Boulat Khakimov <boulat@inet-interactif.com> writes:

    bk> How do I grant permissions on everything in the selected
    bk> databes?

    bk> GRANT doesnt take as on object database name nor does it
    bk> accept wild chars....

Attached is some Perl code I wrote long ago to do this.  This
particular code was done for Keystone, a problem tracking database and
it would do a "GRANT ALL".  Modify it as needed.  Last I checked it
worked with both PostgreSQL 6.5.x and 7.0.x