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