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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]