The Security screen is a tool to help you restrict access to the database in the generated app.
You can choose one of the following options:
•No Login - there is no authentication. Everyone can access and edit the database.
•Database - choose this method if you store username/password combinations in your database. In this case, you need to select the database table with the user data and choose the fields that store usernames, passwords, and full names. Full name content is displayed in the Logged as <> phrase after successful login.
If you wish to display additional information in the Logged as <> phrase, use the AfterSuccessfulLogin event to add a custom code. For example:
You can create a new table to store user login info by clicking Create new, and add new users to the selected table by clicking Add user.
•Active Directory - this option allows working with the user data stored in the Active Directory. For more information, see Active Directory.
With active authentication, ASPRunnerPro generates an additional ASP page called Login.
Here is how it looks like in the generated app:
The additional security options are located on the right:
•When using authentication, you can set the Login form appearance.
•Registration and passwords option allows you to create and set up the user registration, password reminder, and 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.
•Use the Session keys option to enable a single logon for multiple projects.
•You can set up the Two-factor authentication with the Database option.
•"One or several persons with the same access rights have access to the site".
Use the Hardcoded option.
•"There is a single owner (administrator) with full access. Other users (guests) have read-only access to some pages/reports/charts".
•"There are many users with different access levels and administrators with full access".
Use the Database option, configure Advanced security settings if you need to restrict access for each table, configure User group permissions to assign table level permissions, configure Admin group for administrators.
•"All user account data is stored in the Active Directory".
Use the Active Directory option.
Security screen articles: