Re: [GENERAL] change ownership on all tables

2009-07-31 Thread John R Pierce
Alan McKay wrote: OK, my DB Admin is on vacation, and 15 minutes of googling didn't get me the answer :-) Although in that 15 minutes I could have done all 109 tables manually :-) I know this command for a single table, and checked the manual but don't see anything about wildcards ALTER TABLE

[GENERAL] change ownership on all tables

2009-07-31 Thread Alan McKay
OK, my DB Admin is on vacation, and 15 minutes of googling didn't get me the answer :-) Although in that 15 minutes I could have done all 109 tables manually :-) I know this command for a single table, and checked the manual but don't see anything about wildcards ALTER TABLE tablename OWNER to u