Listed below are This chapter presents some typical security implementations in Servoy applications.

Basic Servoy Authentication 

Practical where the security will be managed by the developer of the application and does not require anyone else configuring users or permissions.

Steps

• Using the User/Group editorEditor, decide what authorization permission groups are required for the application.   Create these groups before development begins.
• During development of tables and forms, use the settings on the security Security tab of each editor to configure what permissions each group has for the table/form.   Keep During form development, keep in mind during form development that elements must be named in order to assign permissions.
• Set the Check the mustAuthenticate flag to true (selected) for of the solution.
• Create users with either the User/Group editor Editor or with the Users page in the application server Application Server administration utility.   Assign users to groups in either editor.
• Deploy the application.   When launching the application, the default login window will appear to authenticate the user.

...

To allow tenant administrators or "'super users" ' to adminstrate administrate users, or if you are when using an external authentication source, you must create custom authentication is required. 

Custom authentication will allow the allows the developer to use a users table in the database for authentication or access an external authentication directory.

...

• If using Servoy for storing user data, create a user table for the application or set of applications.   Be Make sure to at least include a username and password column in the table.
• Create a login solution.   A login solution should have the following attributes:
  • Solution type of login
    
  • A login form set as the first form.
  • The login form should have fields (normally form variables) for entering a username and password
  • A button or method that will validate the fields are not null and finally call the authentication method of the authenticator solution.   See Login Method Login Method Example.
  • The login solution has no database access, so if there is any validation done during the login process (find tenant id, verify user exists, etc.), the login solution must call an authenticator solution for any database information.
•  Create an authenticator solution (during the solution creation process, same as login solution).   The authenticator has the following attributes:
  • Solution type of authenticator
    
  • Includes a global method to authenticate users.   This method will check the users table or call external authentication to authenticate.   This method will also log the user into Servoy.   See Authenticator Authentication Method Example.
  • Can also include other methods for checking a user or getting a tenant id.
  • The authenticator solution is not a module of the solution, but must be in the repository of the application server Application Server or in the developer's workspace. ( It can be set to a module of the solution to make it easier to export and import to the application server Application Server, but it will never run on the client but . It will always stay on the server)Server.
• Set the login solution property to the login solution you have just created.
• Deploy the application, making sure to include the authenticator solution if you do an import is done on the application serverApplication Server.   The custom login form will appear when launching the solution.

Solution onOpen Method

For almost every implementation of security, the solution should have an onOpen method assigned. This event is triggered right after the authentication process is complete. Some of the functions of this method in regards to security include:

• Setting up of tenancy for a multi-tenant solution.   Table filters are enacted at this time to filter the data appropriately for the tenant.
• Applying custom security.   If the security model is custom, these permissions should be set at this time.   This would normally involve reading metadata from the database and applying permissions/restrictions based on the user's group.
• Setting security variables. Normally, in order to better facilitate using information from the users and tenants tables, global variables should be set for the current user id and the current tenant id.   If these variables were not set during the login process, then they should be set here.
• Database switching. If the application is set up as a multi-tenant with a database for each tenant, this is the time to switch to the tenant's database.

...

Login Method Example

The code below is an example of a typical custom login method. In this scenario, the login page contains the following form variables:

...

function login(){

	errorMessage = null;

	if(!userName){
		errorMessage = 'Please specify a user name';
		return false;
	}
	if(!password){
		errorMessage = 'Please specify a password';
		return false;
	}

	var tenantID = security.authenticate("myAuthenticator","getTenant",[userName]);
	if(tenantID){
		if(security.authenticate("myAuthenticator","loginUser",[userName,password])){
			return true;
		} else {
			errorMessage = "No tenant found. Please check your password";
		}
	}
	errorMessage = 'Login Failed';
}

...

Authentication Method Example

The code below is an example of a typical authentication method.

...

When authentication fails, adding a pauze can be useful to discourage brute force password attacks.

Note that you have the choice of querying there is the option to query the database or getting get an external authentication.   You may also read a A user groups table might be read to create the array of groups the user has privileges with. Also not note that the only thing that is returned is a true or false and that reporting errors to the user does not occur at the authenticator authentication level.

Fully Custom Security

...

The developer writes code to assign form and table security to each part of the solution.   This style of solution is normally managed by exclusion: instead of assigning permission to every part, just assign permissions to the part you want controlled.   An example of this working fully custom security can be found on the ServoyForge site in the Servoy Security framework.