----------------------------------------
Hmm.. As I posted in my original post, I've already used the qualified table name when user2 tried to select from user1's table.

select * from user1.table1;

but it still doesn't work. Any idea?
----------------------------------------

I redo the whole test, and it seems to work now. Not sure what was wrong previously...