Re: Change owner

In article <4c7ofb$ps7@cssun.mathcs.emory.edu> johnl@informix.com "Jonathan Leffler" writes: > >How to change owner of a table ? > > There is no official way to do it (apart from drop and recreate). > > Unofficially, suitably authorised users can update the Owner column in > SysTables (and possibly SysIndexes, SysConstraints, etc.). Beware of > how you revoke the privileges which were granted on the table by the > old owner -- WITH GRANT OPTION can make this very tricky to do. Is it also necessary to alter the UNIX owner of the actual '.dat' & '.idx' files (if running SE)? -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================