Originally posted by leonard905 Thanks, but the site does not have what I'm looking for.
Funny, that site lists the "official" Oracle syntax, so if there is not what you are looking for then very probbably you are looking for nonexisting variant of the syntax. You just have to read those railroad diagrams correctly.
As other have allready said, you can have multiple grantees, but not multiple objects in the single OBJECT GRANT command. It's all in the URL jJeff has provided.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Originally posted by leonard905 Thanks, but the site does not have what I'm looking for. I know the correct format for an object but multiple objects
No, the answer is clearly there. You can't grant permissions on multiple objects at the same time.
SQL> create table t1 (x number);
SQL> create table t2 (y number);
SQL> grant select on t1, t2 to b,system;
grant select on t1, t2 to b,system
ERROR at line 1:
ORA-00990: missing or invalid privilege
SQL> grant select on t1 to b,system;