When myDBR is selected as the authentication method, user logins and passwords are defined here.
Login- the login name user uses when (s)he logs in
User's name- Real life name for the user
Password- Password used
Is admin- Determines whether the user is allowed to maintain myDBR reports
Logins are stored into the table
mydbr_userlogin. The password stored using the phpass-algorithm (bcrypt) compatible with newer PHP's password_hash-function.
In order to import large numbers of users into the myDBR user repository, you can import them directly to
mydbr_userlogin-table. password can be either MD5-hash from the password or a password geterated by PHPass. MD5-hashed passwords are automatically converted to salted ones once the password is changed.
insert into mydbr_userlogin( user, password, name, admin ) values ('newuser', md5('password'), 'New User', 0 );
From myDBR 4.0 onwards passwords are stored as salted passwords using PHPass PHPass.