| From: | dev(at)archonet(dot)com |
|---|---|
| To: | Boulat Khakimov <boulat(at)inet-interactif(dot)com> |
| Cc: | 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-06 17:26:12 |
| Message-ID: | 20010306.17261200@client.archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
On 3/6/01, 5:00:47 PM, Boulat Khakimov <boulat(at)inet-interactif(dot)com> wrote
regarding [SQL] Permissons on database:
> Hi,
> How do I grant permissions on everything in the selected databes?
> GRANT doesnt take as on object database name nor does it accept wild
> chars....
By hand at the moment I'm afraid. There is no GRANT ALL ON ALL...
Having said that, if you have plpgsql enabled on that database you could
write a simple loop to do so for you. If you'd find one useful let me
know and I'll knock one up.
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-03-06 17:36:07 | SQL article |
| Previous Message | Oliver Elphick | 2001-03-06 17:09:31 | Re: [SQL] Permissons on database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ERIC Lawson - x52010 | 2001-03-06 20:40:00 | Re: row locking |
| Previous Message | Oliver Elphick | 2001-03-06 17:09:31 | Re: [SQL] Permissons on database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-03-06 17:26:18 | Quick question MySQL --> PgSQL |
| Previous Message | Josh Berkus | 2001-03-06 17:22:25 | Re: No Documentation for to_char(INTERVAL, mask) |