Re: Still no luck with permissions, and GRANT/REVOKE

Posted in 1992

Walt Hultgren {rmy} — Thu, 23 Jan 92 14:26:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!europa.asd.contel.com!uunet!halexii!halexv!greg From: greg@halexv.uucp (Gregory F. Hogg) Newsgroups: comp.databases.informix Message-ID: <1992Jan23.122051.1328@halexv.uucp> Date: 23 Jan 92 12:20:51 GMT References: <1992Jan22.204806.11926@watmath.waterloo.edu> Reply-To: greg@halexv.UUCP (Gregory F. Hogg) Organization: HOGG'S SOFTWARE; Abingdon, MD In article <1992Jan22.204806.11926@watmath.waterloo.edu> dvadura@plg.uwaterloo.ca (Dennis Vadura) writes: >Ok, perhaps someone can help me here. I am still stuck with correctly >setting up access perms for my database. I have a Sun IPX, with version >4.10.UC1 of the engine, and version 4.00.UH1 of the compiler. What I want >is to have several users access the database without having to set their >effective user id's to that of the owner of the database files. I thought >that the whole purpose of grant/revoke was to allow this to be the case. > Dennis, Sounds like you have really having fun, welcome to the wonderful world of INFORMIX :-). Here is what I would check: 1) make sure that the database directory is owned by group INFORMIX with and has permissions 770. 2) make sure that the database directory and all the database files are owned by group INFORMIX and have permissions 660. 3) check the permissions on sqlexec, here are mine: -rwsr-sr-x 1 root informix 248740 Aug 19 1990 /usr/informix/lib/sqlexec > >hmm, actually, does the application program, need to have setuid and setgid >bits turned on? If so this is not in the books that I had a look through >last night. > No, none my 4GL programs have setuid or setgid that should be done by the backgound process sqlexec which is setuid and setgid. +++++++++++++++++ +++++++++++++++++++ Greg Hogg +++ +++ ++ ++ HOGG'S SOFTWARE +++ +++ +++++++++++++++++++ +++++++++++++++++ voice : 410-538-7241 ++++ ++++ ++++ ++++ fax : 410-538-6130 ++++ +++++ +++++ ++++ uucp : uunet!halexii!greg ++++ ++++++ ++++++ ++++ cis : 74176,1320 -- +++++++++++++++++ +++++++++++++++++++ Greg Hogg +++ +++