Reinstall using another database instance. Export both and compare tables with diff or a similar tool. Eventually you'll find it.
When you do, please post back to the list for the benefit of others. Wayne On 7/24/07, B. De Mezzo <[EMAIL PROTECTED]> wrote:
UP ! No more ideas ? B. De Mezzo a écrit : > yes I looked at your link, but it is explained for an older db schema > and it is not usable with the current db shema. The current db seems > to be quite different than the old one. And I can't find how to set > permission with the current db schema. .... > > Anoop kumar V a écrit : >> Did you check the link I sent - I think what you want is done in the >> steps >> mentioned in the link. A normal user is converted into an admin user. >> >> Anoop >> >> On 7/23/07, B. De Mezzo <[EMAIL PROTECTED]> wrote: >>> >>> No :) I don't try to create a new line in the db to get another user. I >>> used the web page ! But I can set (within the derby db) the admin >>> permission for this new user as the db schema evolves and I can't found >>> the right table to update the user permission. >>> >>> Is there someone who know how to set this permission within the db ? >>> >>> Thx ! >>> >>> Anoop kumar V a écrit : >>> > You say that you are trying to create a new user.. directly in the >>> derby >>> > db?? Do you mean you do not have any other continuum user at all >>> whose >>> > password you are aware of? >>> > >>> > On 7/20/07, B. De Mezzo <[EMAIL PROTECTED]> wrote: >>> >> >>> >> :( I try normal kill, killer-kill (-9) then start but still >>> locked. I >>> >> try to register a new user and then use the derby db to modify the >>> >> permission/role for this new user but I was unable to find the table >>> who >>> >> make the link between user and permission/role ... >>> >> >>> >> Here the table list I get : >>> >> ij> show tables; >>> >> TABLE_SCHEM |TABLE_NAME |REMARKS >>> >> >>> ------------------------------------------------------------------------ >>> >>> >> SYS |SYSALIASES | >>> >> SYS |SYSCHECKS | >>> >> SYS |SYSCOLUMNS | >>> >> SYS |SYSCONGLOMERATES | >>> >> SYS |SYSCONSTRAINTS | >>> >> SYS |SYSDEPENDS | >>> >> SYS |SYSFILES | >>> >> SYS |SYSFOREIGNKEYS | >>> >> SYS |SYSKEYS | >>> >> SYS |SYSSCHEMAS | >>> >> SYS |SYSSTATEMENTS | >>> >> SYS |SYSSTATISTICS | >>> >> SYS |SYSTABLES | >>> >> SYS |SYSTRIGGERS | >>> >> SYS |SYSVIEWS | >>> >> SYSIBM |SYSDUMMY1 | >>> >> SA |JDOAUTHENTICATIONKEY | >>> >> SA |JDOUSER | >>> >> SA |JDOUSER_PREVIOUSENCODEDPASSWO&| >>> >> SA |SECURITY_OPERATIONS | >>> >> SA |SECURITY_PERMISSIONS | >>> >> SA |SECURITY_RESOURCES | >>> >> SA |SECURITY_ROLES | >>> >> SA |SECURITY_ROLE_CHILDROLE_MAP | >>> >> SA |SECURITY_ROLE_PERMISSION_MAP | >>> >> SA |SECURITY_USERASSIGNMENT_ROLEN&| >>> >> SA |SECURITY_USER_ASSIGNMENTS | >>> >> >>> >> which is the good one ? >>> >> >>> >> I STILL need help !!! :) but I thank you for your previous >>> comments. >>> >> >>> >> regards. >>> >> >>> >> >>> >> Anoop kumar V a écrit : >>> >> > To restart why not just do a cold start. Use kill to stop >>> (assuming >>> >> > you are >>> >> > on [Li][U]nix) and start continuum. >>> >> > >>> >> > >>> >> > On 7/20/07, B. De Mezzo <[EMAIL PROTECTED]> wrote: >>> >> >> >>> >> >> I try the continuum-restart method (does not work) and try to >>> access >>> >> the >>> >> >> user database and change the 'locked' attribut of sa.JDOUSER but >>> >> it is >>> >> >> already set to 'N' ... >>> >> >> but admin account stills locked :'( >>> >> >> >>> >> >> perhaps by removing the 'admin' entry in the db ? >>> >> >> >>> >> >> Jesse McConnell a écrit : >>> >> >> > should be able to just restart the instance it it will >>> unlock all >>> >> >> > admin accounts >>> >> >> > >>> >> >> > On 7/20/07, Anoop kumar V <[EMAIL PROTECTED]> wrote: >>> >> >> >> If you have not yet found it.. here it is: (one of the ways) >>> >> >> >> >>> >> >> >> >>> >> >> >>> >> >>> http://www.nabble.com/Change-a-user-role-to-build-admin-tf3136881.html#a8692812 >>> >>> >> >>> >> >> >>> >> >> >> >>> >> >> >> >>> >> >> >> Anoop >>> >> >> >> >>> >> >> >> On 7/19/07, Wayne Fay <[EMAIL PROTECTED]> wrote: >>> >> >> >> > >>> >> >> >> > This has been asked (and answered) several times on this >>> list. >>> >> >> Search >>> >> >> >> > the list archives at Nabble.com -- you're bound to find a >>> few >>> >> hits. >>> >> >> >> > And I'd assume its probably documented in the Continuum >>> wiki as >>> >> >> well. >>> >> >> >> > >>> >> >> >> > Wayne >>> >> >> >> > >>> >> >> >> > On 7/19/07, BDM <[EMAIL PROTECTED]> wrote: >>> >> >> >> > > hello, >>> >> >> >> > > I locked my admin account by typing to many times the >>> wrong >>> >> >> >> password (I >>> >> >> >> > > have checked later that it was the good one ... strange) >>> >> !!! But >>> >> >> now >>> >> >> >> > > how can I unlock this main account ???? >>> >> >> >> > > >>> >> >> >> > > >>> >> >> >> > > Thx !! >>> >> >> >> > > >>> >> >> >> > >>> >> >> >> >>> >> >> > >>> >> >> > >>> >> >> >>> >> >> >>> >> > >>> >> >>> >> >>> > >>> >>> >> > > >
