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 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 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 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 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 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 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 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 !! > >>> >> >> >> > > > >>> >> >> >> > > >>> >> >> >> > >>> >> >> > > >>> >> >> > > >>> >> >> > >>> >> >> > >>> >> > > >>> >> > >>> >> > >>> > > >>> > >>> > >> > > > > > > > >