Re: An Alternative to Reinstalling Informix SE 7.2....

It looks like your permissions are still wrong. I havent dont it, but try running the install scripts that are still in $INFORMIXDIR. Murray Wood ----- Original Message ----- From: <mabin001@tc.umn.edu> To: <informix-list@iiug.org> Sent: Saturday, 22 May, 1999 05:10 Subject: An Alternative to Reinstalling Informix SE 7.2.... > A system administrator, while copying load-ready files from tape to our > unix machine, inadvertently deleted the entire /usr/informix directory > structure. Prior to this catastrophe, he had copied the directory > structure (as root) under another directory location. He tried > recovering from this mistake by restoring the /usr/informix directory > structure from the backup, as I soon discovered, everything was owned > by root now and then belonged to the system group. I changed the > ownership and group attributes of all the informix files back to > informix, but could not connect to the databse. I discovered that the > permission flags on the database directories and the files inside > weren't set right either. After creating a test database with a test > table, I was able to use the permission attributes of the test database > as a model restore the other database file permissions. > > After these shennanigans, I was able to connect to the database, but > later, discovered that the users were still having problems running > ISQL reports and forms.Are there any specific file permissions that the > ISQL report and form components have to have? > > Other information: public has connect permission. > Update,Delete,Select and Insert permission is granted at the table > level for all users. > > The sys admin, temporarily added the users to the informix group (!) to > allow the users continued access to the data, reports and forms. > > Is a reinstallation of informix (and then the subsequent recreation of > the database and re-loading of data) the most effective solution to > this problem? (And perhaps the revoking of the sys admin's root > privileges!) > > Thanks > > > --== Sent via Deja.com http://www.deja.com/ ==-- > ---Share what you know. Learn what you don't.--- >