RE: INFORMIX-SE 4.11,UC1 how to connect?

Posted in 2006

Topics: Security, Permissions & Auditing

Simmons, Keith — Thu, 9 Feb 2006 09:03:49 -0000 — source: Usenet: comp.databases.informix

ph You need to login as Informix, access an SQL session and run the command "GRANT CONNECT to PUBLIC" against your database. Keith -> -----Original Message----- -> From: ph [mailto:piotr_h@tlen.pl] -> Sent: Thursday, February 09, 2006 7:32 AM -> To: informix-list@iiug.org -> Subject: Re: INFORMIX-SE 4.11,UC1 how to connect? -> -> -> Thanks for your answer -> -> But because I'm completely new in INFORMIX and UNIX area, -> I have some additional problems with this export. -> This is short description how it looks in my situation: -> 1.Informix directory is -> /usr/informix -> 2.Databases are located in -> /users/gw_ver01/gw/db_gw.dbs -> /users/gw_ver02/db/db_gw.dbs -> 3.From /usr/Informix/bin I run dbschema -> ./dbschema -t all -d /users/gw_ver01/gw/db_gw -> -> and I get message: -> -> DBSCHEMA Schema Utility INFORMIX-SQL Version 4.11.UC1 -> Copyright (C) Informix Software, Inc., 1984-1991 -> Software Serial Number AAA#E871595 -> No connect permission. -> -> 4.I'm in Informix group but work on my own account -> What other permission do I need? -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************

↪ replying to Simmons, Keith

ph — 9 Feb 2006 02:46:42 -0800 — source: Usenet: comp.databases.informix

it will be possible login as informix user, can you write how start SQL session

↪ replying to ph

Jonathan Stowe — Thu, 09 Feb 2006 11:15:56 +0000 — source: Usenet: comp.databases.informix

On Thu, 2006-02-09 at 10:46, ph wrote: > it will be possible login as informix user, can you write how start SQL > session Er, you use the program 'dbaccess'. /J\\ -- This e-mail is sponsored by http://www.integration-house.com/