user in lowercase

>> pbalakrishnan@symantec.com (Puru Balakrishnan) writes .. >>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 Hi Puru, Since I started using OnLine 5.x I have made sure that my users are defined within double quotes... Eg: GRANT CONNECT TO "user1" ; My Version(s) of DBACCESS do not recognise the owner as lower characters when accessing information on the tables or when inserting into "xxx".tabname. I created synonyms for the tables and that ran OK. I hope this addresses your problem, Tom Hogarty < Standard Disclaimers Apply > Siemens Nixdorf Informationsystems Paderborn, Germany e-mail : hogarty.pad@sni.de