Re: need help with GRANT to 2 users

> 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

You can't so stop trying. To do what you are trying to do takes four separate statements.

Daniel A. Morgan Received on Thu Mar 08 2001 - 00:10:28 CST