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