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