ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries
Access][DB2 UDB]SQL0551 - Not authorized to object AUTH_USER in MYLIB type
*FILE. (-551) (SQLExecDirectW)')
2011/9/7 Omi Chiba <ochib...@gmail.com>
> >How about using auth with as400 users. Is it possible?
> I'm not sure about it since I'm still new for web2py but your problem
> should be related to the permission just like your error says.
>
> My library is like...
>
> Object secured by authorization list . . . . . . . . . . . .
> *NONE
>
> Object
> User Group
> Authority
> *PUBLIC
> *CHANGE
> QSECOFR
> *ALL
>
> and my user has...
> Special authority . . . . . . . SPCAUT *ALLOBJ
>
> Maybe create new library and connect with the most high authority user
> might help.
>
>
>
>
> On Sep 6, 4:49 pm, António Ramos <ramstei...@gmail.com> wrote:
> > Ok, seems to get someting now.
> >
> > I have to change in AS400 the permissions to allow my username to create
> a
> > table
> >
> > ProgrammingError: ('42000', '[42000] [IBM][Controlador ODBC do iSeries
> > Access][DB2 UDB]SQL0551 - Not authorized to object **** in *N type
> *USRPRF.
> > (-551) (SQLExecDirectW)')
> >
> > How about using auth with as400 users. Is it possible?
> >
> > Thank you
> >
> > Em 6 de setembro de 2011 22:07, António Ramos <ramstei...@gmail.com
> >escreveu:
> >
> >
> >
> >
> >
> >
> >
> > > I tried the DAL Example and i could not connect to my AS400
> > > does the DAL only works with db2 on windows or linux?
> >
> > > i have my db2 in a OS400 machine
> >
> > > Thank you
> >
> > > António
> >
> > > Em 6 de setembro de 2011 21:56, António Ramos <ramstei...@gmail.com
> >escreveu:
> >
> > > Great
> > >> i tested the example from the python shell and i connected to my
> company
> > >> AS400 with success.
> >
> > >> FANTASTIC!!!!
> >
> > >> Tomorrow i will kick the ass of the RPG guy.
> >
> > >> :)
> >
> > >> 2011/9/6 Massimo Di Pierro <massimo.dipie...@gmail.com>
> >
> > >>>
> http://ochiba77.blogspot.com/2011/09/how-to-connect-db2-with-python-p...
