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: garry@schoolteachers.co.uk
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] grant privileges
> Date: Sat, 8 Nov 2008 13:33:24 +0000
> CC: akretschmer@spamfence.net
>
> On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote:
> > Garry Saddington <garry@schoolteachers.co.uk> 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
Click here