Re: grant privileges

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