Re: Permissions Problem

I'm using Informix-SE 7.2 on a Sparc Ultra Enterprise running Solaris 2.5.2. The grant statement is: "GRANT ALL ON customers TO denise" I've run the statement as "informix" and as me (as I own the database) and neither works. }Vasili M. Kolovos wrote: }> }> This is a multi-part message in MIME format. }> }> ------=_NextPart_000_000D_01BCDFA7.2C15F420 }> Content-Type: text/plain; }> charset="x-user-defined" }> Content-Transfer-Encoding: quoted-printable }> }> I created a new database using Informix-SE and have a problem granting = }> permissions to users. I create the SQL statement, and it executes = }> correctly telling me that permissions have been granted. The user shows = }> up in the 'sysusers' table correctly, but NOTHING shows up in = }> 'systabauth'. Does anyone know what that problem might be. Please = }> respond via e-mail as my news reader has been malfunctioning as of late. }> }> Vasili M. Kolovos }> MIS Supervisor }> Active Medical, Inc. }> } }Vasili, } }What's your Informix version, What does your GRANT statement look like? } }Dragi "Bonzi" Raos } }+--------------------------------------------------------+ }| 4-MATE Information Engineering Inc. | }+--------------------------+-----------------------------+ }| 4-MATE | Tel: +385 (1) 242-116 | }| Kosa bb | +385 (1) 242-126 | }| 10000 Zagreb | Fax: +385 (1) 242-121 | }| Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | }| | URL: http://www.4mate.hr | }+--------------------------+-----------------------------+ }