Postgres Pro
Downloads
Home   >   mailing lists

Thread: grant privileges

grant privileges

From
Garry Saddington
Date:
Is there a way to grant all priveleges on all tables and sequences in a
database at the same time?
regards
Garry

Re: grant privileges

From
Raymond O'Donnell
Date:
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
------------------------------------------------------------------

Re: grant privileges

From
Andreas Kretschmer
Date:
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°

Re: grant privileges

From
Garry Saddington
Date:
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

Re: grant privileges

From
Martin Gainty
Date:
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