No, the answer is clearly there. You can't grant permissions on multiple objects at the same time.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
Code:SQL> create table t1 (x number); Table created. SQL> create table t2 (y number); Table created. 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; Grant succeeded. SQL>




Reply With Quote