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@lfix.co.uk> Sent by: pgsql-admin-owner@postgresql.org
08/16/2005 05:00 PM Please respond to olly
To: Andrew Gold <agold@cbamedia.com> cc: pgsql-admin@postgresql.org 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@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
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives?