Re: need help with GRANT to 2 users

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

• 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