Informix Error 387 No Connect Permission
Technote (troubleshooting) Problem(Abstract) You try to connect or select a database but you see errors 387 and 111. Symptom -387 No connect permission. -111 ISAM error: no record found. Cause The user trying to connect does not have connect privilege for this database. Resolving the problem 1. Connect to the database as a DBA user, informix, or the user who created the database. 2. grant connect to username username - name of user trying to connect to the database. GRANT statement Database-Level Privileges Document information More support for: Informix Servers Software version: 10.0, 11.1, 11.5, 11.7 Operating system(s): AIX, HP-UX, Linux, Mac OS X, Solaris, Windows Reference #: 1424400 Modified date: 2011-04-16 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
No connect permission??? Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 13 ] 1 Topic by junior 2012-06-21 09:14:27 junior Member Offline Registered: 2003-11-02 Posts: 541 Topic: dbexport - No connect permission??? At attempt of export of basis produces an error- 387 - No connect permission.- 111 - ISAM error: no record found.In what a problem? 2 Reply by Andron 2012-06-21 09:27:28 Andron Member Offline Registered: 2002-01-28 Posts: 1,665 Re: dbexport - No connect permission??? Problem in ignorance of English language :-)No coonect permission - there are no rights to connection to basis etc. 3 Reply by Zhuravlyov Denis 2012-06-21 09:32:28 Zhuravlyov http://www-01.ibm.com/support/docview.wss?uid=swg21424400 Denis Member Offline Registered: 2012-05-02 Posts: 4,768 Re: dbexport - No connect permission??? In a name of a DB an error 4 Reply by junior 2012-06-21 09:39:28 junior Member Offline Registered: 2003-11-02 Posts: 541 Re: dbexport - No connect permission??? to AndronWith English at me everything is all right. At least with English-speaking students I communicate freely. A problem at me in ignorance of Informiksa!to ZhuravlyovIn a DB name as though all http://www.progtown.com/topic723965-dbexport-no-connect-permission.html . Tried some times. Here something another. Probably absolutely elementary. About what to experts and in a head not . 5 Reply by junior 2012-06-21 10:03:28 junior Member Offline Registered: 2003-11-02 Posts: 541 Re: dbexport - No connect permission??? Additional question: how to learn a name of the current user in the console?I mean, when the server only is launched, without coming in dbaccess. 6 Reply by Zhuravlyov Denis 2012-06-21 10:06:29 Zhuravlyov Denis Member Offline Registered: 2012-05-02 Posts: 4,768 Re: dbexport - No connect permission??? man whoami 7 Reply by junior 2012-06-21 11:18:29 junior Member Offline Registered: 2003-11-02 Posts: 541 Re: dbexport - No connect permission??? man is for UNIX. At me Win2000 AdvServ. 8 Reply by cpr 2012-06-21 19:08:29 cpr Member Offline Registered: 2012-05-06 Posts: 608 Re: dbexport - No connect permission??? Is not present unambiguouslyMake you will not understand yetgrant connect to public; 9 Reply by vasilis 2012-06-21 17:11:30 vasilis Member Offline Registered: 2012-05-06 Posts: 2,063 Re: dbexport - No connect permission??? > An additional question: how to learn a name of the current user in the console?> I mean, when the server only is launched, without coming in dbaccess...> man is for UNIX. At me Win2000 AdvServ.1. To push three known keys consoles Ctr-Alt_Del and to look on the screen2. If it is
Registrarse Foro de la Comunidad SIU » http://comunidad.siu.edu.ar/foro/index.php?topic=7051.0 SIU-Guaraní » Informix (Moderador: Alejandro Delú) » [SOLUCIONADO] dbexport error « anterior próximo » Imprimir Páginas: [1] Autor Tema: [SOLUCIONADO] dbexport error https://groups.google.com/d/topic/comp.databases.informix/IzYwbX73Hs4 (Leído 875 veces) 0 Usuarios y 2 Visitantes están viendo este tema. pablo_unq Guarani Mensajes: 498 Institución: Uiversidad Nacional de Quilmes Nombre informix error y apellido: pablo romero Sistema: 01143657100 Teléfono laboral: siu_guarani [SOLUCIONADO] dbexport error « : marzo 27, 2014, 01:22:31 pm » Hola:Creamos una base (version 2.64) desde cero y cuando quiero exportar la base me aparece algo rarisimo.-387 - No connect permission.-111 - ISAM error: no informix error 387 record found.Hay otra base en la misma instancia y la exporta bien.Que permiso me puede faltar?.Muchas gracias!!!! « Última Modificación: marzo 31, 2014, 10:41:16 am por ibisso » En línea ibisso Moderador Global Mensajes: 186 Institución: SIU Nombre y apellido: Ignacio Bisso Re:dbexport error « Respuesta #1 : marzo 27, 2014, 03:11:31 pm » Hola,Al usuario con el que estas intentando hacer e dbexport, le fala permiso de connect a la basetenes que entrar al dbaccess o sqleditor como usuario Informix, seleccionar la base que queres exportar y ejecutar unGRANT CONNECT TO el_usuario_que_va_a_hacer_el_exportsalutes!Ignacio En línea Imprimir Páginas: [1] « anterior próximo » Foro de la Comunidad SIU » SIU-Guaraní » Informix (Moderador: Alejandro Delú) » [SOLUCIONADO] dbexport error Comunidad SIU SMF 2.0.1 | SMF © 2011, Simple Machines XHTML RSS WAP2
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen