Hello Dag and all,
thank you very much! I did two mistakes:
1) Typing error
Property key is derby.database.fullAccessUsers and
derby.database.readOnlyAccessUsers, not only derby.fullAccessUsers and
derby.readOnlyAccessUsers.
2) Missing derby.connection.requireAuthentication
This property has to be set to true, if I wish to use authentication.
Now I achived what I want ("mimic" sa account) with this derby.properties:
derby.database.defaultConnectionMode=noAccess
derby.connection.requireAuthentication=true
derby.authentication.provider=BUILTIN
derby.user.sa=veryStrongPwd
derby.user.readonly=readonly
derby.database.fullAccessUsers=sa
derby.database.readOnlyAccessUsers=readonly
Thank you very much for your help!
--
Hezky den / Have a nice day
Libor JELÍNEK
http://devblog.virtage.com
2011/5/5 Dag H. Wanvik <[email protected]>
> Libor Jelinek <[email protected]> writes:
>
> > *derby.database.defaultConnectionMode=noAccess
> > derby.authentication.provider=BUILTIN
> > derby.user.sa=veryStrongPwd
> > derby.user.readonly=readonly
> > derby.fullAccessUsers=sa
> > derby.readonlyAccessUsers=readonly
>
> Ooops, I missed the fact that you had misspelt these two properties:
>
> derby.fullAccessUsers=sa
> derby.readonlyAccessUsers=readonly
>
> They should be:
>
> derby.database.fullAccessUsers=sa
> derby.database.readonlyAccessUsers=readonly
>
> Thanks,
> Dag
>
