why does this happen:
grant select on table1 to user1;
grant insert,update,select,delete on table2 to user1;
insert into table2 select * from table1;
error: table1: Permission Denied
?
Do I need write permission on a table to do an insert into ...select... on
it?
--tony
