At 4/9/2001 09:07 PM (Monday), Marc Leclerc wrote:

>My users want to use their full names for login, as anyone got a nice way
>to do this. It seems that IB does not like spaces in user names such as
>"John Doe".

This is quite feasible but will take a bit of work.

I is quite possible to make the Interbase security database (ISC4.GBD)
available as a normal Interbase database. You client program could read the
list of user accounts from this database and match against a user's name
entered at a login dialog. The table which holds user accounts includes
fields for long names as well as the short username and password. The
client program could then initiate a login using the short name and the
same password the user entered.

A couple of points worth noting:
1) You have to maintain the long names as well as the short names.
2) You need to ensure the long names are not duplicated so you can actually
identify a specific record.
3) You need to be careful of rights to change the records in the security
database since this is a prime target for breakin attempts.