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