Postgres Pro
Downloads
Home   >   mailing lists

Re: Granting privelges on several tables at a time - Mailing list pgsql-novice

From Thom Brown
Subject Re: Granting privelges on several tables at a time
Date
Msg-id AANLkTiniw6vQVVWoJWfwub1Dq-D1KMlElwke6lOjCnX0@mail.gmail.com
Whole thread Raw
In response to Granting privelges on several tables at a time  (Atif Jung <atifjung@gmail.com>)
Responses Re: Granting privelges on several tables at a time  (John DeSoi <desoi@pgedit.com>)
List pgsql-novice
Tree view 
On 23 June 2010 10:10, Atif Jung <atifjung@gmail.com> wrote:
> Is it possible to grant a user 'ALL' privileges to all tables in a database
> in one command?
> Atif
>
>

Only in version 9.0.  I believe you'd have to grant on each database
one at a time or write a script/function to do it for you.

Regards

Thom

pgsql-novice by date:

Previous
From: Atif Jung
Date:
Subject: Granting privelges on several tables at a time
Next
From: Atif Jung
Date:
Subject: Insert error