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