if its possible to generate the list of tables from a sql query then do something like
\o out.sql select ' grant select on table1 to ' || tablename || ' ;' ; \i out.sql
regds mallah.
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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
