Hi,

I am pretty new to DB2 (and SQL as well), and run into a few
questions:

1) Is there anybody that knows if there is a way to write the
following in one SQL statement?:
grant select on table agent to user a, user b, user c;
grant select on table customer to user a, user b, user c;
grant select on table product to user a, user b, user c;
(there are more tables, but only these shoould the users get rights
on)

and 2) Is it possible to grant select rights onto only a few columns
of a table?
If so, what does the command look like? (also one command for more
columns possible?)

Thank you in advance.
Eric