Re: Permissions Problem

Vasili, Did you do a grant connect to the user? Yours, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov ********************************* On Tue, 28 Oct 1997, Vasili M. Kolovos wrote: } 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 | } }+--------------------------+-----------------------------+ } } } }