|
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@xxxxxxxxxxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: grant privileges > Date: Sat, 8 Nov 2008 13:33:24 +0000 > CC: akretschmer@xxxxxxxxxxxxx > > On Saturday 08 November 2008 13:01, Andreas Kretschmer wrote: > > Garry Saddington <garry@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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 |
