what is systables.owner used for?
Posted in 2009
joe asked what systables.owner is for, why some owners are blank, and whether it can be updated. Serge Rielau first answered as if it were DB2, then retracted. Fernando Nunes explained the column records who created the table and matters for permissions. It must not be changed by UPDATE, which is unsupported and risks corruption; only recreating the table changes the owner. The blank owner is used in some system tables.
Topics: General Discussion
I don't understand what systable.owner this column is used for ? In my database, there are many different owner names include empty character . It depend on whom created this tables, but what about the empty space come from ? Any influence on this column 'systable.owner' ? Can I modify this column By issue " update systables set ownere='xxxxx' "?
joe wrote: > I don't understand what systable.owner this column is used for ? > In my database, there are many different owner names include empty > character . > It depend on whom created this tables, > but what about the empty space come from ? > Any influence on this column 'systable.owner' ? > Can I modify this column By issue > " update systables set ownere='xxxxx' "? Joe, Which version of DB2 are you talking about and what is the exact table name. In DB2 for LUW SYSIBM.SYSTABLES is really none of your business. You should be looking at SYSCAT.TABLES The owner of a table is typically the definer of the table. But ownership can be transfered. I'm not clear how you could see an empty owner unless you went through great lengths to define a login " " Cheers Serge -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab
joe wrote: > I don't understand what systable.owner this column is used for ? > In my database, there are many different owner names include empty > character . > It depend on whom created this tables, > but what about the empty space come from ? > Any influence on this column 'systable.owner' ? > Can I modify this column By issue > " update systables set ownere='xxxxx' "? For those who saw my post before I canceled it. My apologies...got my wires crossed and forgot I was reading the Informix group... -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab
On Thu, Aug 20, 2009 at 1:18 PM, Serge Rielau <srielau@ca.ibm.com> wrote: > joe wrote: > > I don't understand what systable.owner this column is used for ? > > In my database, there are many different owner names include empty > > character . > > It depend on whom created this tables, > > but what about the empty space come from ? > > Any influence on this column 'systable.owner' ? > > Can I modify this column By issue > > " update systables set ownere='xxxxx' "? > For those who saw my post before I canceled it. My apologies...got my > wires crossed and forgot I was reading the Informix group... > > > -- > Serge Rielau > SQL Architect DB2 for LUW > IBM Toronto Lab > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Serge, this is not DB2... (I suppose). The column "owner" defines who created the table. It's abosulutely important for several reasons (permissions rights mainly). You CANNOT change the owner by doing an update on systables. Unfortunately the only way to change the owner is by recreating the table. Doing that update is completely unsupported and you'll probably get your database corrupted. The space in the owner is used in a few system tables. Don't worry about it. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...