[Mapbender-dev] primary key for mb_user_name?

[Christoph Baudson]

Another problem occurs, when users forget their passwords. The only 
thing they have is the username. It's impossible to send a new password 
to this specific user if there are other users with the same username.

Christoph

Michael Schulz schrieb:
> Hi,
> 
> i agree with Christoph, the main cause for a unique username is the
> fact, that the user table is possibly filled from another source than
> the web registration form (I had to do that). Thus the table
> definition should reflect the unique user name constraint as the
> application already assumes it (e.g. the maxLogin functionality that
> uses username).
> 
> I couldn't think of a contra argument, but then i don't know the code
> by heart as Uli and the others do.
> 
> Cheers, Michael
> 
> 
> On 8/7/06, Uli Rothstein <uli.rothstein at ccgis.de> wrote:
>> Hi,
>>
>> do we realy need a unique user name?
>> This is a basic decision and there are some pros and cons:
>> * the application works with the user_id if the user is authenticated 
>> by name
>> and password
>> * the maxLogin disables an account by username
>> Certainly there are much more arguments.
>> Let's start a discussion....
>>
>> Regards
>> Uli
>>
>>
>>
>>
>>
>>
>>
>>
>> Astrid Emde schrieb:
>> > Christoph Baudson schrieb:
>> >> Astrid,
>> >>
>> >>> Only for the login, we ask for the mb_user_name. After we checked the
>> >>> authentication we go on with the mb_user_id.
>> >>
>> >> Although the registration procedure checks, if this username is taken,
>> >> it might occur that a database entry comes from another source but the
>> >> registration form on the web, f.e. a command line entry or a different
>> >> module (someone adds his own registration module for instance).
>> >>
>> >> Because the user name needs to be unique, it should be reflected in
>> >> the database too, so adding a UNIQUE constraint should suffice.
>> >
>> > Hi christoph,
>> >
>> > now I unterstand your point and agree to the primary key on the column
>> > mb_user_name.
>> >
>> > Astrid
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: dev-unsubscribe at mapbender.osgeo.org
>> > For additional commands, e-mail: dev-help at mapbender.osgeo.org
>> >
>>
>>
>> -- 
>> --------------------------------
>>         Ulrich Rothstein
>>           CCGIS GbR
>>         Siemensstraße 8
>>          53121 Bonn
>>            GERMANY
>> --------------------------------
>>
>>    uli.rothstein at ccgis.de
>>         www.ccgis.de
>>     www.mapbender.org
>> --------------------------------
>> Zentrale:  ++49 (0) 228 90826  0
>> Durchwahl: ++49 (0) 228 90826 17
>> Fax:       ++49 (0) 228 90826 11
>> --------------------------------
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe at mapbender.osgeo.org
>> For additional commands, e-mail: dev-help at mapbender.osgeo.org
>>
>>
> 
>