| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Andrew Gold <agold(at)cbamedia(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: GRANT ALL PRIVILEGES ON DATABASE |
| Date: | 2005-08-17 00:00:33 |
| Message-ID: | 1124236833.12095.101.camel@linda |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote:
> Obviously, I can write a script to iterate through all the tables, but
> what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it
> doesn't even grant basic access?
See the man page for GRANT.
It gives the right to create schemas and temporary tables in the
database.
--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-17 03:02:46 | Re: Is there anyway to create a functional index using to_date? |
| Previous Message | Andrew Gold | 2005-08-16 23:17:33 | GRANT ALL PRIVILEGES ON DATABASE |