Re: need help with GRANT to 2 users

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

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.
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net