Good Morning Garry- if you dont mind command line you can categorise your GRANTS into ROLES e.g. CREATE role Name Identified BY OBAMA
then grant the necessary privs to that specific role grant <Priv> to role then pass the granted tole to the user grant role to user <WITH ADMIN OPTION> WITH ADMIN OPTION allows the user the ability to pass grants to deserving students HTH Martin Gainty DBA Instructor ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] grant privileges > Date: Sat, 8 Nov 2008 13:33:24 +0000 > CC: [EMAIL PROTECTED] > > On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote: > > Garry Saddington <[EMAIL PROTECTED]> schrieb: > > > Is there a way to grant all priveleges on all tables and sequences in a > > > database at the same time? > > > Thanks I've just installed pgAdmin and that has done the trick. > Regards > Garry > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general _________________________________________________________________ See how Windows® connects the people, information, and fun that are part of your life http://clk.atdmt.com/MRT/go/119463819/direct/01/
