You can password-protect access to your database with PHPRunner. You can choose one the following options:
•No Login - there is no authentication.
•Hardcoded - all your users will use the same hardcoded login/password combination.
•Database - choose this method if you store username/password combinations in your database. In this case you need to choose database table with username/passwords data and fields that store usernames, passwords and user full name that will be displayed in the Logged as <> phrase. You can create new login table by clicking Create new and add new users to this table by clicking Add user.
If it is necessary to display something more complex than just one field in the Logged as <> phrase, you can use AfterSuccessfulLogin event and, for example, the following code:
$_SESSION["UserName"] = $data["FirstName"].' '.$data["LastName"]
For more information about Login with Facebook option, see Facebook connect.
•Active Directory - Active Directory authentication. For more information, see Active Directory.
If using authentication PHPRunner will generate additional PHP page login.php intended for username and password validation.
Registration and passwords allows you to create user self-register page, password reminder, change password pages. Use Locking and Audit to set up record locking and user actions logging. Use Encryption to encrypt important data in the database. When using authentication, choose Login form appearance. If Database or Active Directory option is selected, you can set Advanced Security Settings and define Permissions.
If you need to customize email templates that will be send to the users/admins when a new user is registered use the Email templates dialog.
Example of Login page:
If you have selected the Remember Password check box and then opens one of the internal page of application, such as a Menu or List page, you will be logged in automatically.
Scenarios on how you can configure security options
•"Only one person or several persons with the same access rights have access to the site" - use the Hardcoded username and password option.
•"There are the site administrator (owner) and guests. The administrator has full access to the site, guests have read-only access to some pages/reports/charts" - use the Username and password from database option, enable guest login in the Advanced security settings, configure the access for guests in the User group permissions.
•"There are many users with different access levels and administrators with the full access" - use the Username and password from database option, configure Advanced security settings if you need to restrict the access within one table, configure User group permissions to assign table level permissions, configure Admin group for administrators.
•"If all user accounts and passwords are stored in the Active Directory" - use the Active Directory option.