Re: DB2-SQL questions (grant...)

"Eric" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
>
I don't know which DB2 platform you are running, but all this information is
contained in the SQL Reference for the appropriate DB2 you are running. You
can download the manual from the IBM website:
http://www-3.ibm.com/software/data/pubs/
The manuals are at the bottom of the screen.