| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | MaRcElO PeReIrA <gandalf_mp(at)yahoo(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Grant on several tables at once |
| Date: | 2003-08-01 20:14:55 |
| Message-ID: | 3F2ACA3F.10800@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
MaRcElO PeReIrA wrote:
> Hello All,
>
> I have a database that contain 72 tables. How can I grant "SELECT" on
> all those 72 tables to a user, at once?
>
> I use to do:
>
> # grant select on table1 to marcelo;
> # grant select on table2 to marcelo;
> # ...
> # grant select on table72 to marcelo;
>
> but it is a lot of tables... I would like to do this at once!
>
> Thanks in advance and
> Best Regards,
>
> Marcelo
Hi Marcelo,
you will need a tool for that. pgAdmin2 (win32 only) can grant on
multiple objects at once, pgAdmin3 lacks this feature at the moment.
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2003-08-01 20:15:20 | Re: Grant on several tables at once |
| Previous Message | MaRcElO PeReIrA | 2003-08-01 20:06:10 | Grant on several tables at once |