grant privileges

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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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?

No, but there are several solutions for that:

14:00 < akretschmer> ??grantall
14:00 < pg_docbot_adz> For information about 'grantall' see:
14:00 < pg_docbot_adz> http://www.onlamp.com/databases/2006/01/19/examples/plperl-article-2.sql :: http://pgedit.com/public/sql/acl_admin/index.html ::
http://unf.be/postgresql/postgres_grant_all.perl :: http://www.archonet.com/pgdocs/grant-all.html

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�

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

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
http://clk.atdmt.com/MRT/go/119463819/direct/01/