grants on mutiple tables and to multiple users

[leonard905]

Hi,

can you grant a privilege on multiple tables and to multple users. See below example:

grant select on (TEMP1,temp2,temp3,temp4) to user1,user2,user3;


I got an "invalid table name" error message.

Please help!!


Thanks,