Re: Table Ownership, Changin

} } From: Brian Lee } >Hi- } > } >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? } > } >Thanks, } > } >Brian Lee } > } >Anasaszi, Inc. } >7500 N. Dreamy Draw Drive Suite 120 } >Phoenix, Az 85020 } >brian@anasazi.com } } Brian, } I don't recommend changing the ownership of tables, however, I have in the past } done this by executing the following SQL statement: } } update systables set owner = "newusername" where tabname = "targettable" } } You must also change the file permissions of the .dat file found in the .dbs } directory of your database to the newusername (i.e. chown targettable.dat } newusername). } } Dave Mascorro } dave@oncology.uthscsa.edu } University of Texas Health Science Center at San Antonio I can hear Jonathon L. now. In fact, I'm probably hearing an echo from the last time permissions and ownerships was 'discussed'. The ringing in my ears goes something like this. NO!!!!!!!!!!!!! NOT!!!!!!!!!!!! NEVER!!!!!!!!!!!!!! WHAT PART OF NO DON'T YOU UNDERSTAND???????? Sorry Jonathon, I could't resist. I have had similar problems with folks I deal with. If the truth be told, I am sure that I have been guilty of the same thing. Take a big enough club up along side my head and I learn. ;-) George Teachman USDA-SCS Fort Collins, CO