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? http://archives.postgresql.org