Could you tell us what is the best way to grant a user who can select all data from all tables, if I don't like to write a script which Andrew memtioned earlier.
Thanks.
| Oliver Elphick <olly@xxxxxxxxxx>
Sent by: pgsql-admin-owner@xxxxxxxxxxxxxx 08/16/2005 05:00 PM
|
To: Andrew Gold <agold@xxxxxxxxxxxx> cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] GRANT ALL PRIVILEGES ON DATABASE |
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@xxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
