Step By Step
I have UNIX AIX V4 et Informix 4. I just begin with Informix and i behin build Database. On the IBM RS6000, it's allready application. I connect my with "root' (administrator). I go in the directory of application i run "Informix with /usr/infomrix/bin/isql". i go select databases who is display but the system give two error : 387 : no connect permission 111 : ISAM error : no record found with "ls -l" i see : drwxrwxrwx .................................. stores.dbs I have all right on this file. Why i can't open it ? How to open database ? BRUNO
Bruno SITOT wrote: > > I have UNIX AIX V4 et Informix 4. I just begin with Informix and i > behin build Database. > On the IBM RS6000, it's allready application. > I connect my with "root' (administrator). I go in the directory of > application > i run "Informix with /usr/infomrix/bin/isql". i go select databases > who is display but the system give two error : > 387 : no connect permission > 111 : ISAM error : no record found > > with "ls -l" i see : > drwxrwxrwx .................................. stores.dbs > I have all right on this file. Why i can't open it ? How to open > database ? Being root doesn't give you special privileges on databases. You've reset the permissions on the database, which is a terrible thing to do; anybody can delete the entire database. Reset the directory permissions to 770, and make sure the group is informix. Now, who created the database. You've pretty much conclusively proved it wasn't root, so some other user did. You can probably tell by looking at the owner of the stores.dbs directory. That owner has to give other people permission to access the database. If that person doesn't grant root (or public, a special pseudo-user meaning anybody) permission to access the database, you do not get to access the database -- period. Except, of course, that you have root privileges. So, if you know enough, you can (a) find out who does own the database, su to that user, grant root the privileges you want, and then get on with life as root again, or (b) revise the permissions information directly to suit yourself. Both these options show that you have to be able to trust root, even though root is not automatically trusted by the Informix databases. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>