need help with GRANT to 2 users

From: <_at_hotmail.com>
Date: Thu, 08 Mar 2001 05:14:52 GMT
Message-ID: <3AA6C30A.C348499B@hotmail.com>

Please help - I cannot figure what silly mistake I am making. If new users are already defined as 'pa' and 'ma,' how can I grant both of them privileges on multiple tables in the same query?

grant select on sales_rep, customer to pa, ma

                      *

ERROR at line 1:
ORA-00990: missing or invalid privilege

thanks so much. Received on Wed Mar 07 2001 - 23:14:52 CST