Question..ownership

There is 2 ways to do this. Either you make a dbexport, change the owner and then make a dbimport. The other way is to change to owner in the systemcatalog by updating owner in systables, sysindexes, syssynonyms, sysprocedures, systriggers. If you use this way of changing ownership, remember to change views if any, made by the old owner before you change ownership of the table. Within the viewtext coloum within the sysviews table the '<owner>.<tabname>' is saved as text. One more thing to beware of is grantor and grantee if the old owner is out of the database. Change it to the new owner. Bjarne W. Jensen /Alm. Brand Denmark