>
>> At 07:50 PM 22/10/2007, you wrote:
>>
>> >Does the second martin have the exact same password?
>>
>> Makes no difference. It's the user that gets authenticated;
>> passwords change. The ACL in the database knows martin, but
>> not his password....
>>
>> ./heLen
>>

At 08:24 PM 22/10/2007, you wrote:

>Err, if it's a different martin, and they don't share their passwords, how
>the heck is each of them ever going to log onto the other (relative to
>themselves) machine?

Exactly. Martin Knappe's 'martin' user name won't work on the new server unless the user 'martin' there has the same password. So, if they are different people both using the user name, then it needs sorting out, *before* porting the database.

>(unless of course we're talking embedded and they share the same role... )

It's the same problem, except here the authentication database doesn't enter the picture. User 'martin' has all of user martin's privileges.

./heLen

>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://www.firebirdsql.org and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>