Re: Problem with Informix Online 7.01

I'm debating whether to say RTFM or not. It is covered in there. Unless you surrond the user name with quotes (which should be single quotes since you are using 7.10 -- it won't actually matter unless you have the DELIMIDENT environment variable set, though), the user ID is converted to upper-case in accordance with the ANSI SQL standard. This applies everywhere you might use an authorization ID (aka user name). It has applied to MODE ANSI databases since 4.00.UC1, so it is not new behaviour. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: pbalakrishnan@symantec.com (Puru Balakrishnan) }Date: 22 Jul 1995 01:35:22 GMT }X-Informix-List-Id: <news.15641> } }I am using Informix Online 7.01C1 on Sun Solaris 2.4. While adding a new user to a database }created as ANSI-compatible, all the users are added to the sysusers table in UPPERCASE though }the login id is in lowercase. As a result, new users are unable to connect to the database. } }Eg: GRANT CONNECT TO user1 ; } }A select performed on sysusers would display } } username usertype priority password } USER1 C 5 } }I have other databases which are created , but not ANSI-complaint and the above process }works fine. } }Any thoughts on this would be appreciated. } }Thanks. } }Puru Balakrishnan }Symantec Corporation