| From: | Roland Roberts <roland(at)astrofoto(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: [SQL] Permissons on database |
| Date: | 2001-03-07 20:40:44 |
| Message-ID: | m2puftmhwz.fsf@tycho.rlent.pnet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
>>>>> "bk" == Boulat Khakimov <boulat(at)inet-interactif(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-03-07 20:53:02 | CONTRIB: int8 sequence simulator |
| Previous Message | Matthew | 2001-03-07 20:07:25 | RE: SELECT performance drop v 6.5 -> 7.0.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Bradley | 2001-03-07 22:04:23 | Postgre and Redhat 7.0 |
| Previous Message | Tamsin | 2001-03-07 15:46:15 | RE: ambiguous |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dev | 2001-03-07 21:41:27 | Re: Newbie: execute function error! |
| Previous Message | Rachel Coin | 2001-03-07 19:06:48 | work on rows |