Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: need help with GRANT to 2 users

Re: need help with GRANT to 2 users

From: <psu14_at_localnet.com>
Date: 18 Mar 2001 00:14:05 GMT
Message-ID: <990ukd$cg2$1@news.netmar.com>

In article <3AA6C30A.C348499B_at_hotmail.com>, srcnckpc <@hotmail.com> writes:
>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.
>

Can't guarantee the syntax is identical from DB2 to Oracle, but in DB2 you must specify what kind of object your grant is for. Try   grant select on table sales_rep, customer to pa, ma

Received on Sat Mar 17 2001 - 18:14:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US