| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: grant privileges |
| Date: | 2008-11-08 12:42:18 |
| Message-ID: | 4915892A.20102@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Spadea | 2008-11-08 12:44:45 | Re: Get interval in months |
| Previous Message | Garry Saddington | 2008-11-08 12:29:37 | grant privileges |