On 08/11/2008 12:29, Garry Saddington wrote: > Is there a way to grant all priveleges on all tables and sequences in a > database at the same time? Not easily, AFAIK - this question comes up from time to time, and you'll find in the archives examples of scripts that pull object names from the system catalogues and use these to generate GRANT commands. You could also try pgAdmin, which has a really handy "Grant wizard" to do this. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general