Table Ownership, Changing

Brian Lee wrote: >I am looking for ideas on changing table ownerships. What I need to do is >change the ownership of all the tables in my database. >Does anyone have any comments on this subject? Why would you want to do that? If you GRANT ALL ON <tablename> TO <user> WITH GRANT OPTION the user will have all the priveleges of the table owner. ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.com Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland =========================================================================