Re: user in lowercase

In article <3v0ggo$4s1@nervous.pdb.sni.de>, Tom Hogarty <hogarty.pad@sni.de> says: > > 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 Hi Tom, It worked! Thanks. Puru Balakrishnan Symantec