Re: Cannot create temp tables

My thanks to Helmut - for anyone's information changing the ownership and permissions to root & 6755 on the following binaries: lib/sqlexec, bin/sgidsh, bin/mkdbsdir, bin/changrp sorted me out. Temp tables no longer a problem Thanks Helmut Nigel In article <34DADB26.DAC62CF7@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes > > >Nigel Booty wrote: > >> Not a corporate problem this but irritating nevertheless. I have SQL >> 4.13.UDI running on SCO UNIX 3.2 and as the creator of a database, I'm >> unable to execute the "CREATE TEMP TABLE table (table_id INTEGER); " >> statement. The error I get is >> >> 261: Cannot create file for table (USER.table) >> 1: Not owner>> >> As USER I get this even if I just create a dummy database. Since I have >> a single user system, I have made sure that /tmp and all directories >> where a temp table might be placed have 777 permissions and there is >> planty of space. If su to informix, I can create the hich then exists in >> /tmp. >> >> I can of course create normal tables. >> >> Can anyone throw light on what I need to do? >> >> I'd be grateful >> >> -- >> Nigel Booty > > Hi Nigel, > >I also had a problem "Not Owner" and the access rigths on the directory were >ok. It was not with creating a temp table but with set explain on. Maybe, >the reason is the same. > >Here is what you should verify: > >Cehck the ownership and access rights of th Informix binaries (in >$INFORMIXDIR/bin). Some of them shuold be root/informix and have a sticky >bit set. The information about the correct owner/group and access rights can >be found in a file called $INFORMIXDIR/etc/onlinefiles (or similar). > >Hope this helps > > >Helmut Leininger >Bull AG >Unix Support >Email: Helmut.Leininger@bull.net > -- Nigel Booty