Re: Table Ownership, Changin

Posted in 1994

"David Mascorro" — 10 Aug 1994 10:23:07 -0400 — source: Informix-list mailing list archive (1991-1998)

Reply to: RE>Table Ownership, Changing 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