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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
