Re: [SQL] Permissons on database
От | Rob Arnold |
---|---|
Тема | Re: [SQL] Permissons on database |
Дата | |
Msg-id | 004a01c0ab64$2e237990$4200fd0a@home обсуждение исходный текст |
Ответ на | Permissons on database (Boulat Khakimov <boulat@inet-interactif.com>) |
Список | pgsql-novice |
Are you looking for "grant all to public" or "grant select to public"? ----- Original Message ----- From: "Roland Roberts" <roland@astrofoto.org> To: <pgsql-sql@postgresql.org>; <pgsql-general@postgresql.org>; <pgsql-novice@postgresql.org> Sent: Wednesday, March 07, 2001 3:40 PM Subject: Re: [SQL] Permissons on database > >>>>> "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 > > ---------------------------------------------------------------------------- ---- > > roland > -- > PGP Key ID: 66 BC 3B CD > Roland B. Roberts, PhD RL Enterprises > roland@rlenter.com 76-15 113th Street, Apt 3B > rbroberts@acm.org Forest Hills, NY 11375 >
В списке pgsql-novice по дате отправления: