Re: GRANT ALL PRIVILEGES ON DATABASE - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: GRANT ALL PRIVILEGES ON DATABASE
Date
Msg-id 1124236833.12095.101.camel@linda
Whole thread Raw
In response to GRANT ALL PRIVILEGES ON DATABASE  (Andrew Gold <agold@cbamedia.com>)
Responses Re: GRANT ALL PRIVILEGES ON DATABASE  (Andrew Gold <agold@cbamedia.com>)
List 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@lfix.co.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


pgsql-admin by date:

Previous
From: Andrew Gold
Date:
Subject: GRANT ALL PRIVILEGES ON DATABASE
Next
From: Tom Lane
Date:
Subject: Re: Is there anyway to create a functional index using to_date?